Hello Everyone,
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.
Hi Somok,
The other way to do what you want is by simply bringing both category and subcategory dimensions onto the mark shelf and to enable the user to choose between categories via a filter (by simply putting the category into the filter shelf). See below.
