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!

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!

Thanks for the suggestion Charles. However, i get an error saying i've used
the same field more than once. in my data table that the pivot is pulling
from i have the following columns: Account, Year, Hours. When i create the
pivot the years are in the columns, account in the rows and the hours is the
data item.



"Charles Williams" wrote:

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!

OK: Try this

Double-click Sum Of Hours label to show the PivotTable field dialogue for
the Hours field
Click Options
Show Data as 'Difference From'
Base Field should be 'Year'
Base Item should be (previous)

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"smw2340" wrote in message
...
Thanks for the suggestion Charles. However, i get an error saying i've
used
the same field more than once. in my data table that the pivot is pulling
from i have the following columns: Account, Year, Hours. When i create
the
pivot the years are in the columns, account in the rows and the hours is
the
data item.



"Charles Williams" wrote:

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!