View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smw2340 smw2340 is offline
external usenet poster
 
Posts: 6
Default calculating variances in pivot tables

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!