Last 13 months Sales

[priyarane]

Hi Experts,

I want to have the Sum(Sales) for last 13 months including current month.

My filter name - MonthYear

My script looks like this for Date fields

     MonthEnd(Date#(Reporting_Date,'YYYYMM')) as Reporting_Date,
     Month(Date#(Reporting_Date,'YYYYMM')) & ' '  & PurgeChar(year(Date#(Reporting_Date,'YYYYMM')),'20') as MonthYear,

You can find my application.

Based on MonthYear selection I should get for last 13 months including current month.

Right now I have Sep14 ony, but tonight I will get total data. So I need to put expression before reload.

[timanshu]

Hi Priya,

1) Create a variable. Example  vCustomDate = Date(AddMonths(Reporting_Date,-13)).

2) write expression as  = Sum({<Reporting_Date='>=$(=vCustomDate)<=Reporting_Date'>}Sales)

This will work for you.

[priyarane]

Hi Tim,

I guess in Expression, we have syntax error,

Could you please correct it? I am not able to get it

[MK_QSL]

What is the Format of MonthYear and Reporting_Date?

[priyarane]

MonthEnd(Date#(Reporting_Date,'YYYYMM')) as Reporting_Date

[MK_QSL]

MonthYear?

[jonathandienst]

Hi

Something like this should do it:

Sum({<Reporting_Date={">=$(=AddMonths(Max(Reporting_Date), -13))"}>} Sales)

HTH

Jonathan