A list is a series of rows that contain related data with column titles in the first row. A long list of of numerical data is not useful until it is organized in a way that is meaningful to the reader. Excel's PivotTable report, also called simply a PivotTable, is an interactive Excel report that summarizes and helps you to understand large amounts of data.
First Pivot Table - created using the Recommended PivotTable feature - in the PivotTable Fields pane (at the top), 4 fields are checked: Fire/Police, Month, Location, and Number. All 4 of these show up in the PivotTable below. If the PivotTable Fields pane is not showing, click any cell in the PivotTable report to display it. Alternatively, you can click on Analyze in the menu and then choose Field List in the Show group at the far right. Note that Classification is not checked in the list of fields at the top part of the pane and thus Classification is not showing in the PivotTable below.
By default, non-numeric fields are added to the ROWS area and numeric fields are added to the VALUES area in the layout section at the bottom of the PivotTable Fields pane. You can filter the report based on the Fire/Police field by dragging this field upward to the FILTERS area. This produces the following report which doesn't distinguish between Fire and Police.
In the PivotTable Fields pane, in the field section, the Location field check box is selected. Location is a non-numeric field so by default it will display in the Rows area and the Location names display at rows in the PivotTable report.
In the PivotTable Fields pane, in the field section, select the Classification field check box which produces the following:
Notice in the layout section, the Classification fields displays as the second field in the ROWS area. In the PivotTable, the Classification names are added as indented row heading under each police precinct location and under each fire station location. Notice that under each precinct location, only the call classifications related to the police department display. Similarly, under station locations, only the call classifications related to the fire department display.
If it is not already there, In the PivotTable Fields pane, from the field section, drag the Month field down to the COLUMNS area. Verify that the Sum of Numbers displays in the VALUES area. This should produce the PivotTable above.
revised 4/1/19. Comments to Bill Pegram, email@example.com