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.
Findings on Salary
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.