I am a newbie so trying to even understand the documentation. I created a pivot table from the Cards cube. The %CONTEXT applies only to a KPI, is it correct?
When it comes to part 2), I also reviewed the %CELL function, I tried to use it but since I am new to Deepsee, I keep messing up:).
Let's say I have the following pivot table
This table is based off the following MDX query:
SELECT NON EMPTY [ScoreDate].[H1].[Score Year].Customers ON 0, NON EMPTY [ScoreGrade].[H2].[Scorer].Customers ON 1 FROM [CARDS]
In order to create an expression that will calculate the growth rate from 2000 to 2001, 2001 t0 2002 and so forth, We are using %CELL. I am simply confused as when I use it, I don't get the correct information.
Log in or create a new account to continue