I have been unable to figure this out. Attached is an example file. I put a manual set of calculations in Col AJ to show what I want.



The pivot is a set of data spanning year and months (column headers), and then descriptive sets in Col A. There's a subtotal of Horses and Rats and then a cum total.

Is it possible to get a running total using a calculated field or something else for this type of pivot?

People tell me it's possible but - well - you know how people talk.

Thanks.

Attached Files

runtotal.xlsx (17.6 KB, 12 views)

Bump ?

You can do running totals, but I'm not sure how to get them to do what you want. But try them out and see where you get.

* Right-click one of the cells in the values area
* Select Show Values As >
* Select Running Total In...
* Choose from the field list
* Click OK

Let me know if you figure anything out. I couldn't make it do anything that was meaningful to my eye with your data.

Thank you gebobs, and you are right, that didn't produce meaningful results. Honestly the values that resulted made no sense to me. I take it that method replaces the existing values with something else. I don't want to replace anything, I need the original values to stay as they are. Then I need one new column that shows a running cumulative total from row to row.

I don't understand how Excel can do any running total, I've never seen it work. Would be very curious if someone has an example where the original values aren't altered?

I suspect it's not possible because the method - a calculated field? (I've struggled with them and not come up with anything) - practically speaking, has to add the value from one row to a calculated value from the row above. Where the formula on every row is different from the formula on every row above and below. How could that even be possible in Excel.

Yet, lots of experts claim this can be done. So I would like to not give up yet. Show me please!