I am trying to use the Outer Set Expression with Total function and it doesn't give me the expected results (i.e. same result as Inner ).
Measure 1 using Inner : sum( {<ExpYrWk = {'202306'}>} Total Vol)
Measure 2 using Outer : {<ExpYrWk = {'202306'}>} sum(Total Vol)
I expected both to give the same result. I am trying to use outer set expression to make my formulas look more easy to read and write. For eg, When I am doing % calculations using Total function with multiple conditions, it becomes a hassle when I have to use multiple conditions like below