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.
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