How about adding a pivot table calculated field called Variance with a
formula something like:
='2008 Hours' - '2007 Hours'
regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
"smw2340" wrote in message
...
i am trying to turn the grand total column into a variance column. I do
not
want to sum the hours in my data set i want to show the difference between
the hours from one year to the next. the data in my pivot table looks
like
this:
Col A: Col B: Col C: Col D:
Account # 2007 Hours 2008 Hours Grand Total
Any suggestions?
Thanks!