Employee turnover calc

OilMan_8490

New Member
Joined
Jul 17, 2019
Messages
1
I am trying to find Employee turnover by Year/Company

I have and employee table and I have created a Calendar table

The employee table has the following columns
ID
Hire Date
Term Date
Company
Active Status

I would like to createa dashboard to show by
Company turnover % by Year (2018 & 2019)-- Matrix Chart
Turnover by Month --- Line Chart (as a whole)

please help...
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,102,510
Messages
5,487,310
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top