12 rolling month

[#1]

Hello All,

I have a problem with my expression, I have a field in my table name DATE  which is like

2011-12-01

2011-11-01

2011-10-01

..

..

..

. I want to filter the report for last 12 month or better to say I need the 12 rolling month in the report.

Any idea is appreciated.

Thanks

Nima

[SunilChauhan]

please see the attached  ,

hope this help

[neetu_singh]

Hi Nima,

you can try this for current 12 rolling month:

=RangeSum(Below(sum({$<Year=,Month=,[Cal Year]=,[Year Month]=,OrderDate={"<=$(vMaxDate) >=$(vRollingDate)"}>}

NetSales),0,12))

Variable values are:

1) vMaxDate = (Max(OrderDate))

2) vRollingDate = AddMonths(Max(OrderDate),-11)

Hope it will help you.

Thanks & Regards

Neetu Singh