I have a table that shows counts and percentages of two categories - i will call them cat 1 and cat 2. These two categories are grouped by codes.
So code 1 has a group 1 and 2, code 2 also has corresponding group 1 and 2 and display counts and percentages in columns.
When I add grand total at the bottom of the chart, the percentage ends up becoming 200% as each category is 100% respectively. Is there a way show grand total of each category without having to using filter?