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.