This content has been marked as final. Show 2 replies
I came across a situation where I need to create a drilldown in tree map. Eg. I have Category -> Sub-Category already added under the hierarchy.
now I am showing the sum of sales in treemap. I would like to first show the tree map of Category and when I click on individual category only the relevant sub category would fill the chart.
Eg : When I click on "Technology" as category I would like my tree map should fill the tree map with sub category "Technology Phones", "Technology Copiers", "Technology Machines", "Technology Accessories".
Please find the attached sheet.