View Single Post
 
Old 02-26-2015, 05:45 PM
Chancy Chancy is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default Running total possible in a pivot table?

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
File Type: xlsx runtotal.xlsx (17.6 KB, 12 views)
Reply With Quote