on 12-04-2014 4:11 PM
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é
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.