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,
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture0-1024x530.png)
Step1: Create a Set from Category
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture1-1.png)
Step2: Create a calculated field for Category, another for Subcategory
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture2-1.png)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture3-1.png)
Step3: Put the Category Calculation on rows after Category, untick ‘show header’ to hide the Category column; Replace Subcategory with the Subcategory Calculation.
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Screenshot-161-1024x576.png)
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.
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture4-2.png)
Enjoy
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture5-2-1024x605.png)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture6-2-1024x611.png)