Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've got a Pivot Table with a dimension called GLGroup placed in the row
position. Within GLGroup, I've got the descriptions Sales, COS, Expenses, Other. Is it possible to create a calculated item based on your selections within GLGroup? For example, I would want a calculated item called GrossMargin for the GLGroup(Sales) less GLGroup(COS). Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formulas referencing pivot table cells | Excel Worksheet Functions | |||
Custom Views in Pivot Table | Excel Discussion (Misc queries) | |||
Can I set my custom views on Pivot table | Excel Discussion (Misc queries) | |||
Custom Grouping on Pivot Table | Excel Worksheet Functions | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |