we need to create a quick table calculation that shows the percent of total sales for each category and sub- category. To do this, we can follow these steps:
* Drag Category to Columns and Sub-Category to Rows.
* Drag Sales to Text on the Marks card.
* Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.
* Right-click Sales on the Marks card again and select Compute Using > Category.
This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this: