running total calculated field

[aborg88]

hello wise excel gurus,

I come asking your humble advise....

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

rank by date....

This is the revenue and sums up as the rank increases....

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

[noboffinme]

Hi,

I would use a calculated field, can you post a file with your data (or dummy data if it's sensitive)?

Thanks