Fields
The pivot table shown is based on two fields: Department and Last. The Department field is configured as a Row field, and the Last field is a Value field, added twice:
The Last field has been added twice as a value field. The first instance has been renamed “Count”, and set summarize by count:
The second instance has been renamed to “%”. The summarize value setting is also Count, Show Values As is set to percentage of grand total:
Steps
Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
