New post
Max is an Avid Reader. No contributions for 2024.
Without a doubt, there will be something to
share on the Community in 2025!
User bio
404 bio not found
Member since Aug 30, 2022
Posts:
show all 1
Replies:
show all 1
Max Maduri · Aug 31, 2022

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.

Certifications & Credly badges:
Max has no Certifications & Credly badges yet.
Global Masters badges:
Max has no Global Masters badges yet.
Followers:
Max has no followers yet.
Following:
Max has not followed anybody yet.