Pivot_Workforce
Insert a Pivot Table on the Pivot_Workforce_Dashboard sheet. Bring Category and Departments in the ROW area. Bring Salary in the VALUES area three times. Change the functions to MIN, MAX and AVERAGE.
PivotTable Fields
Choose fields to add to report:
bhp ID ✓ Department Category Pay Status Classification Annual Hite Date State of Residence Sex Birthdate Mental Status Education
MORE TABLES…
Drag fields between areas • love
T FILTERS
X
ql COLUMNS
IE Values
You don’t have to create a chart/graph for this. You can use this table itself and write your key findings. You might want to compare Management/Union salaries. Write about the lowest salary and highest salary, and the department they belong to. Other items you might consider including a pie-chart to depict Management/Union category, a column chart for Education, a line chart for Hire Date, a pictograph for gender, etc