Note: the source data contains data for an entire year, but the pivot table is filtered to show only the first 6 months of the year, January through June.
Fields
The source data contains three fields: Issue, Date, and Priority. All three fields are used to create the pivot table:
The Date field has been added as a Row field and grouped by month:
The Priority field has been added as a Column field. The Issue field has been added as a Value field and renamed “Count” for clarity. Because Issue contains text field, the calculation is automatically set to Count:
COUNTIFS alternative
As an alternative to a pivot table, you can use the COUNTIFS function to count by month, as seen in this example.
Steps
Notes
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.