G
GarethG
I have some pivot tables set up that use an Access mdb file as its data
source. I am trying to use formulas such as Calculated
field/Calculated item.
My data is sorted by month, by year, by product etc.
an example would be ¦Customer¦£ Value 2003¦Kg Value 2003¦£ Value2002¦Kg
Value2002
At the end of this I would like to add two calculated fields that work
out the % variation i.e £ 2003 Vs £ 2002
Normally I would hand code this in after I have pasted the table over
to a blank work sheet, but this seems such a waste.
Normally it would be ((£ Value 2003-£ Value 2002)/£ Value 2002)
I would then cell the cell format to a percentage.
How can I add a formula to the pivot table to calculate this rather
than hand code it.
Another point I better make is that the dates are derived from grouped
dates so in the original pivot table there would be a field called
"Date" but now I have years because of the applied groupings. I am
struggling because it does not like calculating grouped fields.
Any one?
GarethG
source. I am trying to use formulas such as Calculated
field/Calculated item.
My data is sorted by month, by year, by product etc.
an example would be ¦Customer¦£ Value 2003¦Kg Value 2003¦£ Value2002¦Kg
Value2002
At the end of this I would like to add two calculated fields that work
out the % variation i.e £ 2003 Vs £ 2002
Normally I would hand code this in after I have pasted the table over
to a blank work sheet, but this seems such a waste.
Normally it would be ((£ Value 2003-£ Value 2002)/£ Value 2002)
I would then cell the cell format to a percentage.
How can I add a formula to the pivot table to calculate this rather
than hand code it.
Another point I better make is that the dates are derived from grouped
dates so in the original pivot table there would be a field called
"Date" but now I have years because of the applied groupings. I am
struggling because it does not like calculating grouped fields.
Any one?
GarethG