set analysis

[#1]

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

[MK_QSL]

may be you have given criteria < and >....

USE <= AND >= in your set analysis

[nikhilgarg]

HEy,

Can you share the script you have written for this  ??

[Gysbert_Wassenaar]

sum({<MyYearField={'$(=only(MyYearField)+1)'}>} sales )

[nikhilgarg]

Hey,

But Only() will be used in case if it has only 1 value.

Isn't it ??

Thanks

[Agis-Kalogiannis]

The way Vijaya describes the problem though implies only one selection so Gysbert's solution will work.

Unless he can become more specific.

[#7]

thank you all

[Agis-Kalogiannis]

Hi Vijaya

Could you please mark one of the answers as Helpful or Correct so as to close the discussion?

Thanks

Agis