I have a pivot table of sales data. First column is customer names, then other columns are months Jan-12, Feb-12 and so on.
Excel automatically adds up the total sales at the foot of each monthly column 'Grand Totals'. I would like a pivot table row to sit immediately below it that gives cumulative sales as the months progress to the right.
I suspect it will involve using 'calculated field/item' (so it updates on a refresh) but would be grateful for an expert's guidance.
Thank you
Replies (3)
Please login or register to join the discussion.
See this link
http://www.excelforum.com/excel-general/726744-excel-2007-two-pivot-tabl...
To get the cumulative values, add the £ field to the pivot table again and change the Field Settings for this to Show values as Running Total in Yr/Pd
Thanks, but this doesn't fix it.
Thanks Stevie, but this doesn't fix it.
I need the cumulative row to be dynamic & integral to the pivot table.
Not a separate row external to the table that links into pivot cells.
Did you try
Stevie's suggestion in his final sentence? Because this should get you very close. The disadvantage being that you will also get running totals by customer as well so, rather than being an extra row, each month will have a column for the month's total and a cumulative column.