The pivot table shows the count of employees in each department along with a percentage breakdown.
Fields
The pivot table shown is based on two fields:DepartmentandLast.
Pivot table count with percentage
To display data in categories with a count and percentage breakdown, you can use a pivot table. In the example shown, the field "Last" has been added as a value field twice – once to show count, once to show percentage.
