1

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?

3
  • relevant Jan 29, 2014 at 20:14
  • @Raystafarian I found that when searching and have actually used that method as a temporary workaround. However, it does not answer the pivot table element of the question.
    – simon3k
    Jan 29, 2014 at 20:44
  • You'll need to mess around with calculated fields and calculated items. Jan 29, 2014 at 21:00

1 Answer 1

0

This is perhaps not ideal, but could you adapt something like this?

enter image description here

1
  • I can't find a way to adapt that. The possibilites for calculated fields in the pivot table seem quite limited, I'm not sure if it is capable of referencing data in a different row, or column totals.
    – simon3k
    Jan 31, 2014 at 14:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .