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é
Maybe take a look at the time dependent calculations in this best practice document by Andreas? SAP Lumira Calculation Best Practices
Add a comment