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
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
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??
