G
Guest
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
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