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.   

Pivot table issue count by priority - 89Pivot table issue count by priority - 99Pivot table issue count by priority - 51