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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,450
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top