Is it possible to create a reverse running total in an Excel 2010 pivot table?
Using the basic example below, I have a list of number of sales per month (B), along with a running total (C). Without changing the order of the rows, is it possible to create a reverse running total column (D) in the pivot table?
A | B | C | D
--------|---|---|---
January |5 |5 |25
February|7 |12 |20
March |4 |16 |13
April |9 |25 |9
I know this can be acheived easily outside the pivot table, but I'd like a more elegant solution which can't break when the pivot table is refreshed. Excel doesn't have a option for this on "Value Field Settings"/"Show Values As" on the pivot table so maybe something with calculated fields would be able to do it?