Forum Discussion
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 If your data is in columns as shown below, enter into cells I2 and N2 the formulas shown just below them.
(In your spreadsheet, row 3 will be empty, or contain your next row of data. I got the formulas to appear in mine by entering "=FORMULATEXT(I2)" and "=FORMULATEXT(N2)" into cells I3 and N3, respectively, without the quotes.)
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?
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.
