Charts

[#1]

if the user selects the year to see the values on charts then the previous year value should get reflected.

for example if the user selects 2006 from the list box the chart should reflect the values of 2005 .

Please  help its urgent??

[#2]

Hi,

Try:

Year={'$(=(max(Year)-1))'},

When we select Year=2006, The Max(Year)=2006 -> -1 -> 2005.

[perumal_41]

Hi,

Try: this expression

Sum({<Year={'$(=(max(Year)-1))'}>}Value)

Regards

Perumal A

[#4]

where i have 2 right this expression

[perumal_41]

Hi,

Expression Tab in Chart Properties

Regards

Perumal A

[#6]

Not working!!!!!!!!

[#7]

Not working >>>>> can u plz give a small example

[#8]

my years are in the list box and chart is gauge chart

[perumal_41]

Hi,

Please Upload ur example Application.

Regards

perumal A

[#10]

may be i have 2  pass the value using the variable to the chart expression ?????? m not sure