Hi I have a question regarding pivot table and grouping. I have a table that displays every employee along with their hire date and termination date (if applicable). I want to know how I can count how many people were hired/fired and group them by month. I have attached a sample with the expected results highlighted. Problem I keep getting is I can't manipulate the rows in the pivot table to show just months and have the columns populate independently.
Count of Employee Dates.xlsx
Any help is greatly Appreciated
Bookmarks