Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Within a pivot table, how can I calculate a VARIANCE between 2 columns,
rather than the default "Grand Total" as shown below (i.e., I need to see a variance of 8 on the Dog/Male row, rather than the "total" of 12) ? Animal Gender Born Sold Grand Total Dog Male 10 2 12 Female 5 2 7 Cat Male 1 1 2 Female 3 2 5 Hamster Male 6 3 9 Female 2 1 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Variance help | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals/Variance Analysis | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |