View Single Post
  #1   Report Post  
Kirk P.
 
Posts: n/a
Default 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?