Set Analysis for last 13 months of Data

[Anonymous]

Hi Friends,

Attached his the file which contains 3 years of data, i want to build a LINE chart via set analysis which shows last 13 months of Amount as of today. Please any one can help me on this.

Regards,

Ankit Month

[Anonymous]

THANK YOU Every one, Different way of calculation was useful in lot of ways

[jagan]

Hi Ankit,

I think this is the best expression, even if you select year or month this will always show last 13 months amount

=SUM({<Year=, Month, YearMonth = {"<=$(=Date(MonthStart(Today()),'YYYYMM')),'YYYYMM'))>=$(=Date(MonthStart(Today(),-12),'YYYYMM'))"}>}Amount)

Hope this helps you.

Regards,

Jagan.

[MK_QSL]

Hi Ankit,

What Jagan is saying is right... The formula I have provided need to be edited by using ByPASS of certain fields..

Year=, Month = ,

[Anonymous]

Thanks Jagan..