Forum Discussion
Tony_Shingler440
Nov 06, 2022Copper Contributor
Pivot Table Column Totals
Hi All I want to subtotal several Date columns then go on to add further columns to give in the right hand edge a YTD figure. Eg: I have x8 columns under Jan to Aug which I want to total across, th...
Tony_Shingler440
Nov 07, 2022Copper Contributor
Hi Your formula don't seem to take account that my data is in a Pivot Table and I can't seem to add the subtotal columns I want. Is that correct?
HansVogelaar
Nov 07, 2022MVP
As far as I know, it is not possible to do what you want in a pivot table.
The values of the added column would be included in the Grand Total column at the right, invalidating it.