| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table and Calculated Field | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| calculated field in a pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
