Double "calculated field' for Pivot Table
 

Is there any way of creating a calculated field based on another calculated
field? Allow me to explain.

I have fields:
Time
Amount

I've grouped Time, by Year & Month.

I then am looking at the Amount by:
Monthly Average
% Difference of Prior Year (example May 06 vs. May 05)
Running Total in Year (ie. YTD for Time)

What I want to do:
% Difference of Running Total in Year (YTD) vs. Prior Year.

Is this possible?

TIA,
Mindy

Double "calculated field' for Pivot Table
 

Sorry, this really isn't a calculated field.. it is a field option for a
pivot data field. However can I use a calculated field to get the info I was
looking for?

HELP!

"mmb" wrote:

Is there any way of creating a calculated field based on another calculated
field? Allow me to explain.

I have fields:
Time
Amount

I've grouped Time, by Year & Month.

I then am looking at the Amount by:
Monthly Average
% Difference of Prior Year (example May 06 vs. May 05)
Running Total in Year (ie. YTD for Time)

What I want to do:
% Difference of Running Total in Year (YTD) vs. Prior Year.

Is this possible?

TIA,
Mindy