Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
So I'm doing calculated fields among data elements, but is there a way to do calculated fields among row elements? So say my pivot table looks like this my have: Region | Data US Sum of Potatoes Sum of Apples Sum of Potatoes + Apples [<-calculated field] INTL Sum of Potatoes Sum of Apples Sum of Potatoes + Apples [<-calculated field] Is there a way to easily get [US minus INTL]? I guess this is essentially a different Grand Total summary. Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot tables - calculated fields and items | Excel Discussion (Misc queries) | |||
Pivot Tables - how do I add in calculated fields? | Excel Worksheet Functions | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
Pivot tables - calculated fields | Excel Worksheet Functions | |||
Pivot Tables, calculated fields | Excel Discussion (Misc queries) |