Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks
I have a line/bar chart where onve of the expressions is:
Sum
(Value1) - above(Sum(Value1))
This gives me the movement between two periods as the dimension is QuarterEnd, the problem is that when I use the above() function the chart will give me an additional plot/data after the last Quarter. For example, I have selected a reporting date of 30 Jun 2008 (which gives me a dataset of everything prior to that date) but my chart gives me a bar after 30 jun 2008 with no date on it.
Anybody experienced this?
If you have, have you found a solution?
Cheers,
Nigel.
Hi try this fromula
if(date = '30 jun 2008',sum(Values1),sum(Values1) - above(sum(Values1))
I hope it ll help for u
-Sathish
Does it look different if you use:
sum(Value1) - above(Sum(Value1))
-Rob