Need help in splitting the Employee Count based on joining date between several months of the year. I have employee database that contains records of employee and say I have 400 employees that have joined in past year. Now I need to show a report that will list down Employees count whose value will split across months from previous year. Here, say my year range is Oct 2017 to Sep 2018.
Example: Below is what my report should look like.
Employee Type TOTAL COUNT Oct 2017 Nov 2017 Dec 2017... . .. . ..... . . Aug 2018 Sept 2018