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.