Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having a scenario.In that I have to find out sales on month wise.For that am using
expression as above(Sum(Sales))-Sum(sales).In that case it showing month wise difference.But when I clicked
some month it is not showing any value.So please let me know how to proceed further
Hi
What is your dimension Month ? If so
above(Sum(Sales))-Sum(sales) calculate the difference of sales between to 2 consecutive month
So if you clicked some month, you loose the previous dimension you need at least 2 month
JJ
Try using set analysis instead. That should work for you.