Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I understand that Set analysis is calculated only once per chart and not row by row. Is the only option to solve this; is by using an IF statement?
I have a sample application attached wherein I have used an IF statement but I do not get the right output. Can someone point me the right direction?
I want to calculate the difference in Sales over the Years. I dont want to use the ABOVE function. Wanted to see how it can done with IF statement. See the sample application attached.
Try:
=sum({$<Year={$(=max(Year))}>}Sales)-sum({$<Year={$(=max(Year)-1)}>}Sales)
I want the answer to be
Year Difference in Sales
1998 -58
1999 47
which I could get using Sum(Sales) - above(Sum(Sales)) with Year as dimension. Is there anyway to do it with IF statement and set analysis.
Above is designed to do that so I do not think there is a way but I maybe wrong and someone else has the answer.