On selecting any year how to get result of previous year

[piyush01]

i want previous year data on my guage chart, on selecting any year from year list box..I need help to do so

[#2]

Hi,

Add some set analyses in your expression like:

sum({<Year={"$(=max(Year)-1)>} Sales)

Succes, Halmar

[piyush01]

Thanx Halmar...it works

[#4]

Hi Halmar,

       When I am trying this same one I didnt get any data.Do I need to change any syntex?

-Jai

[piyush01 · Accepted solution]

Actually the syntax send by our friend Halmar Heijnen has something missing....so, when you compare both the syntax you will come to about the error. Right syntax is bellow....

=sum({$<Year={"$(vMax1)"}>} Sales)

[SunilChauhan]

hi jai

you can use this code

sum({<year={"$(=max(year)-1)"}>} sale)

[SunilChauhan]

piyush still

$(vMax1) needs to define

[piyush01]

Hi Sunil,

vMax is a variable

=Max(Year)-1....

nw fine?

[SunilChauhan]

good