Straight table to show activity for last 12 months

[jagjivvt]

Hi,

i know that by placing the period in the dimension and using a Pivot would provide me this information but i want to create the same using a straight table. i have tried various ways using set analysis but have had no result.

Count({$<BYear={"$(vBYearPrev)"}, BPeriod ={"$(vBPeriod)"}>} DISTINCT [Employee No])  -----this will provide for start month but need to follow this for the next 11 months

this is the expression that i am using

thanks

vijay    

[jagjivvt · Accepted solution]

Hi

i used the following and it works for me

count({<Year_Month={"$(=Date(Addmonths(Date#(vYearMonth,'YYYY-MM'),-4),'YYYY-MM'))"}>}DISTINCT [Employee No])