Part IV: Managing and Analyzing Data
FIGURE 30.1
This table doesn’t have any numeric fields, but you can use it to generate the PivotTable
shown next to it.A workbook that demonstrates the pivot table created from non-numeric data is available on this book’s
website at http://www.wiley.com/go/excel2019bible. The file is named employee list.xlsx.Here are the PivotTable Fields task pane settings we used for this PivotTable:■ The Gender field is used for the Columns.■ (^) The Location field is used for the Rows.
■ Location is also used for the Values, and it is summarized by Count.
■ (^) The PivotTable has the field headers turned off by using the Field Headers toggle
control in the PivotTable Tools Analyze ➪ Show group.
The Employee field is not used. This example uses the Location field for the Values section, but you can actually use
any of the three fields because the PivotTable is displaying a count.
Figure 30.2 shows the PivotTable after making some additional changes.