cancel
Showing results for 
Search instead for 
Did you mean: 

create a Resticted Key Figures in Lumira

Former Member
0 Kudos

Hi All,

I´m trying to create a Resticted Key Figures in Lumira. In my case I have a Measure which is "Sales Revenue" and a "Dimension" which is Year with values 2009 and 2010.

I´m trying to calculate difference in value for Revenue 2010  minus   Revenue 2009. The only way I found to do something like that is to:

1. Create a "New Calculated Dimension" using function "if then else" and it looks like:   if  {Year}=2009 then  {Sales Revenue}  else  0  to calculate   Sales Revenue 2009

2. Create another  "New Calculated Dimension" using function "if then else" and it looks like:   if  {Year}=2010 then  {Sales Revenue}  else  0  to calculate  Sales Revenue 2010

3. Create a measure based on Sales Revenue 2009 and Sales Revenue 2010

4. and finally create "New Calculated Measure"  with formula {SALES REVENUE 2010} - {SALES REVENUE 2009}

IS THIS THE CORRECT WAY TO CALCULATE A Resticted Key Figures in Lumira? Does anyone has a more "direct and elegant" way to do it?

Thanks in advance for feedback,

Regards,

René

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Maybe take a look at the time dependent calculations in this best practice document by Andreas?

Answers (0)