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:
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit