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