Pivot chart measure to see total active employees on beginning of month and end of month

Hi,

I have a data set with the organizations employees. I am trying to create a pivot table where I want to filter data of only active employees at starting of month and end of month. I have name of employees, start date, terminate date, status, pay type in the data set. I can move the columns around, so that's not an issue.
The problem is, the usual filter doesn't pick up an employee who is currently terminated and was active last month as the status shows terminated.
Any help would be appreciated.

if it is not possible in pivot as a measure, then excel formula would do too.

Below is for reference


1111111.png

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

If I am understanding correctly then no formula is needed. Filter the Start date to be before 3/1/2022 and then filter the termination data for all blanks. You can then do a count of the remaining employees