Let's create a visualization with two table functions computed at different levels using Sample - Superstore. Let's start with the following:
- On a blank Worksheet, put Sub-Category in Rows, and Segment and Sales in Columns.
- Put Sales also in Label.
We'd like to see the weight of each segment in a sub-category:
- Right-click on the Sales pill used in the Label and select Quick-Table Calculation, then Percent of Total. Currently, you can see the weight of each sub-category by segment, which is not precisely what we want.
- Right-click on the same pill again, go to Compute Using, and select Table (across). That's it; you can see that the Consumer segment is always the biggest part.
Your visualization should ...