PivotTable Formulas

[GarethG]

I have set up a pivot table. I have been asked to add a column at the
end of the pivot table that calculated the %variance of sales from this
year versus last year.
I tried to create the formula (Calculate Field) after I had grouped my
dates for Months & Years. I had to ungroup these to be able to create
the formula.

I do not see how when I have ungrouped the date to distinguish between
2003 & 2002 in my Pivot formula. Is this possible of am I flogging a
dead horse here?
Any suggestions would be most help ful



Regards GarethG

 

[Debra Dalgleish]

You could add a column to the source table, in which you calculate the
year for each date. For example, =YEAR(B2)

Add this field to the pivot table, and create a Calculated Item for this
field, e.g.: ='2003'/'2002'-1