Last 3 Months

[#1]

Hi Everyone,

I have a scenario where i have to show last 3 months counts. I am using below expression

Count({<MaxAsOfDateInMonthFlag={1}, [Reporting Month]=, [Reporting Quarter]=, [Reporting Year]=, [Reporting MonthYear]=, [Reporting QuarterYear]=,

// [Reporting Date]={'>=$(=MonthStart(vMaxReportDate, -2))<=$(=vMaxReportDate)'},Status={'YELLOW', 'RED'}>} DISTINCT ([Proj ID])),

Kindly correct the expression and i want to display in pivot table current month counts and last months counts

Thank you in advance

[Siva_Sankar]

CurrentMonth Expression:

Count({<MaxAsOfDateInMonthFlag={1}, [Reporting Month]=, [Reporting Quarter]=, [Reporting Year]=, [Reporting MonthYear]=, [Reporting QuarterYear]=,

[Reporting Date]={'>=$(vMaxReportDate)'},Status={'YELLOW', 'RED'}>} DISTINCT ([Proj ID])),

Previous Month Expression:

Count({<MaxAsOfDateInMonthFlag={1}, [Reporting Month]=, [Reporting Quarter]=, [Reporting Year]=, [Reporting MonthYear]=, [Reporting QuarterYear]=,

[Reporting Date]={'$(=Addmonths(vMaxReportDate, -1))'},Status={'YELLOW', 'RED'}>} DISTINCT ([Proj ID])),

[jagan · Accepted solution]

Hi,

Check this link

Set Analysis for certain Point in Time