Hi Alexander,

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

ScoreGrade 2000 2001 2002 2003 2004
A 200 150 85 15 30
B 275 300 25 25 45
C 35 60 55 50 57
D 400 450 350 250 200

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.

Max has no followers yet.
Max has not followed anybody yet.
Global Masters badges:
Max has no Global Masters badges yet.