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?

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