Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I had a weird situation where one of the expression is working fine in local but not in server/access point.
My expression is looking for sum of the Sales value with YTD accumulation.
For the month of January, value of sales if 1000 let's say, for February it's 0. If i select February month, it should show 1000. Which is 1000+0=1000.
Dimensions are Month-Year & Country Region cyclic group.
I'm able to achieve this using various ways i.e Rangesum/Above but in server it's showing 0 instead of 1000 for a particular Country.
above(Total(sum({<Month={'<=$(=max([Month]))'}>}SALES)),0)
Thanks in advance.
Any suggestions please?
swuehl @Oleg
Could anyone help on this?