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?
Bookmarks