Create hierarchy (Category --> SubCategory) with Category being on the top of hierarchy. Drag hierarchy on Columns shelf and Sales on Rows shelf. Add a simple filter on Category and enable "Show Quick Filter" option. Choose Radio Button as control for selecting only a single value for Category. Whenever required, Category can be drilled down to display sales for all the subcategories in the selected Category.
Drag Category followed by Sub Category on Columns shelf and Sales on Rows shelf. Add a simple filter on Category and enable "Show Quick Filter" option. Choose Radio Button as control for selecting only a single value for Category.
Drag Category followed by Sub Category on Columns shelf and Sales on Rows shelf. Add a simple filter on Category. Choose Radio Button as control for selecting only a single value for Category.
Create hierarchy (Category --> SubCategory) with category being on the top of hierarchy. Drag hierarchy on Columns shelf and Sales on Rows shelf. Add a simple filter on Category and choose Radio Button as control for selecting only a single value for Category. Whenever required, Category can be drilled down to display sales for all the subcategories in the selected Category.