Showing headcount for last 12 months

[dlopez]

Hi Community, 

I'm in need of help with the following. I have an employee dataset with their UID, hire date, and term date. I would like to see who was "active" the last 12 months, this would be rolling 12 months for future use, based of the most recent termination date. Any help with this would be greatly appreciated. 

Cheers

[christine_assaad · Accepted solution]

Hi @dlopez 

Please check the attached. Hope it helps. Cheers!

[dlopez]

@christine_assaad ,

Thanks for the solution, I was looking for the data to get "taller" not "wider" but I can take this data table and just "pivot" the data and that should solve my problem. Condense all those date columns to one column called "Active Date", and this would make the data "taller" 

I'm gonna give that a shot now. Thanks for the help!

[christine_assaad]

Sure. In the attached, I tweaked my formula to show the last end date of the month. If you don't want to "make it wider", you can consider the workflow up to the formula tool and neglect the crosstab 🙂

[dlopez]

@christine_assaad 

Perfect, it worked just like I needed it to. Thanks again Christine!