Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team
I have one scenario,please help me to solve
I have data from 2003 to 2015
if i click 2003 i did not get the sales of 2003, from 2004,sales will be displyed on the chart
same way click on 2004. from 2005 sales will be displayed
may be you have given criteria < and >....
USE <= AND >= in your set analysis
HEy,
Can you share the script you have written for this ??
sum({<MyYearField={'$(=only(MyYearField)+1)'}>} sales )
Hey,
But Only() will be used in case if it has only 1 value.
Isn't it ??
Thanks
The way Vijaya describes the problem though implies only one selection so Gysbert's solution will work.
Unless he can become more specific.
thank you all
Hi Vijaya
Could you please mark one of the answers as Helpful or Correct so as to close the discussion?
Thanks
Agis