Set Analysis Optimization

[Anonymous]

Is there any better way of writing the below set expression?

Sum({<Year={'2017'},Quarter={'Q4'}>}InsideSales)+Sum({<Year={'2017'},Quarter={'Q4'}>}WonSales)+Sum({<Year={'2017'},Quarter={'Q4'}>}LikelySales)+Sum({<Year={'2017'},Quarter={'Q4'}>}OutsideSales)

[tresB · Accepted solution]

May be like:

Sum({<Year={'2017'},Quarter={'Q4'}>} Rangesum(InsideSales,WonSales,OutsideSales))

[swuehl]

Not sure how your model looks like and this could be important, but maybe

=Sum({<Year={'2017'},Quarter={'Q4'}>} RangeSum(InsideSales,WonSales,LikelySales,OutsideSales))

[Anonymous]

Thank you.It is working perfectly.