Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
please see the attached ,
hope this help
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