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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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