on 02-05-2016 1:56 AM
Hello
I am trying to do a formula for a calculated meaure that look something like:
sum(MeasureA for DimensionX='01')/sum(MeasureB for DimensionX='01')
I see i can use Sum({Sales}) ForAllExcept [{Product}] as in the user guide but I can not specify the Value in the Dimension. Also saw Runningsum but still not what i need
Any suggestions ?
Kind Regards
Hector
Hi Hector,
You can create a custom calculation in Lumira like below, I tried and this works
Sum(if ({DS1.City (DIM)} = "Austin") then {DS1.Quantity sold} else 0)/Sum(if ({DS1.City (DIM)} = "Dallas") then {DS1.Quantity sold} else 0)
Regards,
Ashutosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.