Pivot Table Column Totals

Question

Hi AllI 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, then add Sept - Dec as individual columns eventually giving a YTD figure in the right end column.&nbsp;Jan&nbsp; Feb&nbsp; Mar&nbsp; Apr&nbsp; May&nbsp; Jun&nbsp; Jul&nbsp; Aug&nbsp; Y-T-Aug&nbsp; &nbsp;Sep&nbsp; Oct&nbsp; Nov&nbsp; Dec&nbsp; &nbsp;YTD1&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp;12

snowman55 · Answer

Tony_Shingler440&nbsp;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.&nbsp; I got the formulas to appear in mine by entering "=FORMULATEXT(I2)" and "=FORMULATEXT(N2)" into cells I3 and N3, respectively, without the quotes.)&nbsp;

tony_shingler440 · Answer

SnowMan55&nbsp;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 · Answer

Tony_Shingler440&nbsp;
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.

Forum Discussion

Pivot Table Column Totals

Share

Resources