Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Running totals in a Pivot table??

Greetings,

How can I set up a running total in my pivot table I would like this to Crete a chart that has a constant upwards look.

All I can figure out is total rows, but that doesn't seem to work. Any help would be appreciated.

Richard (last pic as an example)

iMac 27″, macOS 11.6

Posted on Aug 1, 2022 6:04 PM

Reply
Question marked as Apple recommended

Is this what you are looking for? (I clicked the circled i in the Total Time token in the Values box).




If you want this primarily to create a chart you could also add a "cumulative" column in your data table and plot that.





The formula in C2, of this example, filled down:


=SUM(B$1:B2)


SG

Posted on Aug 1, 2022 8:17 PM

1 reply
Question marked as Apple recommended

Aug 1, 2022 8:17 PM in response to NumberNovice

Is this what you are looking for? (I clicked the circled i in the Total Time token in the Values box).




If you want this primarily to create a chart you could also add a "cumulative" column in your data table and plot that.





The formula in C2, of this example, filled down:


=SUM(B$1:B2)


SG

Running totals in a Pivot table??

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.