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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.