Set Analysis problem?

[khadeer]

Hi All,

I have date field with 2005 to 2012, and amount field with some values. Suppose if i selected for year wise and month wise i am getting correct values.

But if i want data from starting onwards. for example, if i selected year 2010 and month june ... i want the total value from 2005 to selected date that means (2010 june).

Regards,

Khadeer

[er_mohit]

hey try this

sum({<Date_Field={"<=$(=max(Date_Field))"}>}TOTAL Amount)

might be helpful

[khadeer]

Thank u mohhit n wassener, Both r helpful

In wassener post just create variable with =max(Date_Field) and use that varible in chart we r getting answer.