i designed one bar chart...

[balasundaram]

I have designed Barchart. When user opened that chart need to show current Year data. after user selected previous year in year list box,same  bar chart need to show previous data..how to write condition for that?

please tell me

[MayilVahanan · Accepted solution]

HI

Try like this

=Sum({<Year = {"$(=Max(Year))"}>}Amount)

[balasundaram]

thank u very much....machaa