The raw data that I am pulling into Lumira has a YTD sum of units sold as one of the measures. This data is published quarterly. What I want to do in Lumira is:
adjusted qty = If quartermonth = 12 then qty(quartermonth(12)) - qty(quartermonth(9))
What I'm getting at is having Lumira calculate the quarter's actual quantity instead of the running sum that it is giving me.
1
Comment
-
What about breaking up the calculations?
What is your data source? If it is a BEx query it is better to do the calculations in the query
Add comment