Display Active Employees

[danieldors]

Hello,

Im trying to display only the employees which are currently employed as of last month, the field for the employee is PAS-Worker and month is reporting period. 

Thank you

[edwin]

you can do something like count({<Month={'$(vReportingMonth)'}, Status={'Active'}>}[PAS-Worker])

assuming you store your reporting month in a variable and you have a field for status

of course you can have the reporting month as a filter then you wont need it in your set analysis