Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Variances using Pivot Table | Excel Discussion (Misc queries) | |||
Calculating from values in pivot tables | Excel Worksheet Functions | |||
Calculating in Pivot Tables | Excel Discussion (Misc queries) | |||
Calculating fields in pivot tables | Excel Discussion (Misc queries) | |||
Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions |