Last Three months performance

[sunil-kumar5]

Hello All

I have a year and month field in my PMS table and with the help of that I have created a PMSDATE in load script.

date(MakeDate(Year,Pick(Match(Month,'January','February','March','April','May','June','July','August','September'
,'October','November','December'),
'1','2','3','4','5','6','7','8','9','10','11','12'),1),'DD-MM-YYYY') as PMSDATE

and I am getting the date filed perfectly. 

Now in front end by using this date I am trying to get the records for only those employees getting poor from last three months.

Column names in table Emp_Name, Year, Month, PMSDATE, Segment,Final Score

I need to display a table showing the information like 

Emp_Name	Month	Segment	Final Score
ABC	June	Poor	45
ABC	July	Poor	65
ABC	August	Poor	45
XYZ	June	Poor	66
XYZ	July	Poor	55
XYZ	August	Poor	56
JKL	June	Poor	54
JKL	July	Poor	48
JKL	August	Poor	61

In front end under final score column value I am using the measure as below

Sum({<PMSDATE={">=$(=MonthStart(AddMonths(Max(PMSDATE),-3)))<=$(=MonthEnd(AddMonths(Max(PMSDATE),-1)))"},
Segment = {'Poor'}>}FinalScore)

but not getting any result, please advise

Thanks

Sunil Kumar

[sunil-kumar5]

Hello All,

Can anyone please help on this?

Thanks