running total / other field

hello wise excel gurus,

I come asking your humble advise....

I've got a pivot which has a running total,

Problem, I would like to divide this cumulative summed revenue by another field in the pivot (active customers), is this possible?

Hi

you can do by adding calculated field.

See http://www.wikihow.com/Add-Custom-Field-in-Pivot-Table

Cheers