A pivot table is an easy way to count blank values in a data set.
Fields
The pivot table shown is based on three fields: First, Last, and Department.
Any text field in the data that is guaranteed to have data can be used to calculate count.
Steps
Notes
