Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table - Custom Formulas
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? |
#2
|
|||
|
|||
Maybe a visit to Debra Dalgleish's site:
http://www.contextures.com/xlPivot06.html will help. I often add extra columns to the original data and add formulas there. Then I use those extra columns in my pivottable. Kirk P. wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |