I have a query as a Pivot Table view.
I used the button "Auto Calc"
It summs as expected.
I need to add another column that shows the summ as a percent of the overall total.
I can change the Auto Calc sum to "show as percent of Grand Total" but I also lose the subtotals.
How can I add another column that will show the percent of the overall total but keep the subtotals?