HI Anitha,
[Replace category with sub categories]
Follow the below steps:
1. Create a parameter for subcategory and add another option as All.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=15775703190223482608)
2. Now create a calculated field as below, [Replace category with sub categories]
![](https://www.edureka.co/community/?qa=blob&qa_blobid=13379221446409920947)
3. Now drop the above field and sales to show data as wanted.
I used a simple visual as a table you can take as per use.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=11997105737259027439)
![](https://www.edureka.co/community/?qa=blob&qa_blobid=8658270567662293660)
![](https://www.edureka.co/community/?qa=blob&qa_blobid=8269439047075007015)
Hope it helps you!