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

[#2]

HI

TRY IT

SUM(TOTAL( $<YEAR AND MONTH>AMOUNT))

[#3]

Hi khadeer,

Can you share your file, please?

-Anju

[khadeer]

Hi Vishwa,,   Its not working.....    Hi Anju,  PFA

[#5]

Hi,

Can you also please attach your .qvw file?

-Anju

[khadeer]

Just i given one example i cant share my qvw.. file. If i selected 2012 i have to show total amount. If i selected 2011 i have to show until 2011....  if i selected 2011 n any month i ave to show amount from starting date to selected date. I hope its clear.   regards,  Khadeer

[Gysbert_Wassenaar]

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

[khadeer]

i have tried this already. But its not working.  Its giving total value just like sum(Amount)

[#9]

Hi,

I think we have to use something like this

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

but, this again needs some modification =$(=Date) gives current date and =max(TOTAL Date) gives the last date in the list. I tried this, but I am still getting values for only that particular date.For some reason, it is not summing it.

-Anju

[khadeer]

Hi Anju,  Not working. Still its pending.