Per Dundas , A ragged hierarchies can have only the child/leaf nodes so that It can be used in the dashboard. I did exactly the same and now the visuals are pretty good with Parent & Child Hierarchy. I’m able to drill up and down with it. However I have a situation here. My parent records also has some values!!! … So how can i make it visible to the users ?
See the attached image. There is a provision in our front end to just select the parent node and not necessarily select the child node. So few users just select ‘Air and Climate’ and not items under them. So the actual value here is 900 , but only 850 , which belongs to the leaf nodes are shown here. 50 items are missing. Can somebody please let me know how to show them in the drilldown ? So when I drill down ‘Air and Climate’ , I should be able to see ‘Air and climate’ with count of 50 and ‘Greenhouse’ and ‘Outdoor air’ with count of 300 and 550 respectively.