PivotdrillAverage salary by department
A pivot table exercise from Pivotdrill. Solve it with a pivot builder in your browser with Rows, Columns, Values and Filters, and it is checked the moment you submit.
The task
Show the average Salary in each Department.
What this exercise teaches
Summarize Values By changes the calculation. Average divides the sum by the number of records in each group.
A hint if you get stuck
Put Salary in Values, then change its calculation from Sum to Average.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise