Basically, it is a bar chart that drills down when you click on it. We’ve used it a lot in our last client project, it worked quite well for everyone. Let’s go straight to the topic.
Put Category and Subcategory on rows,
Step1: Create a Set from Category
Step2: Create a calculated field for Category, another for Subcategory
Step3: Put the Category Calculation on rows after Category, untick ‘show header’ to hide the Category column; Replace Subcategory with the Subcategory Calculation.
Step4: Set Wooksheet Set Actions (Remove all values from the set when selected); You’ll need to repeat this step again as Dashboard Set Actions later if you are using it on a dashboard.
Enjoy
