Pivot and Cumulative

[Bruce Ocanaan]

Dear all, I have a problem with pivot table. I have a field in column and i0d like to create a formula for do a cumulative value.

Example

Field Cumulative
5 5
5 10
5 15

In excel (not pivot) the formula is =sum($a$1:a1) and drag to all cell of thge column, but how calculate field in a pivot table ?

Can You help me ?



Thank you so much ...

[Cheeky Charlie]

Hi,

Add the same field again, right click an item, field settings - options - running total in - you need to select the last row field in your pivot. If you can't get it, post an example for more specifics.

CC

[Bruce Ocanaan]

Thank you very very much