Pivot Help.. Running Total

M

Mbrocker

I have two pivot data fields:
Time
Amount
Name

I've grouped time by Year/Month
I've changed my Amount field settings to Average, Running Total in
'Year'. This way I get a YTD average amount for each name.

Now, here is my problem. I'd like to know how to set up a field that
will calculate the % Difference From the YTD Average for the prior
year. It's like a 'double' calculation. Is this possible? Is there
a 'calculated field' set up I can use?

I tried Calculated item.. but it doesn't work with Averages.. and it
is important that I stick with averages.

Any help is MOST appreciated

Thanks in Advance!
 
Top