We want the percentage of Sale for each category.

In Marks Card, we have access to Quick Table Calculation and then Percent of Total for each measure

100% is the sum for each year.

% of total in each year across different categories and subcategories.

Grand total column = 100

Grand total row = sum of a row/sum of all rows

100% is the sum for each category.

% of total is calculated for each category across different subcategory and years.

Subtotal of each column is sum of that column / sum of category

Grand total row = sum of that row / sum of category

% of total is calculated in each Year and Category across different Subcategories

% of total is calculated in each category and subcategory across different years