Grouped pivot table

ADumith 

To create a pivot table in Excel 365 that lists support requests grouped by agent and displays requests older than 7 days, follow these steps:

1. Ensure that your support agent data table has the necessary columns, such as creation date, type, requester, assigned agent, and requirement age.
2. Select any cell within your support agent data table.
3. Go to the "Insert" tab in the Excel ribbon and click on "PivotTable" (or "PivotTable" under "Tables" if you're using a newer version of Excel).
4. In the "Create PivotTable" dialog box, make sure the correct range for your support agent data is selected. Choose whether to place the pivot table on a new worksheet or an existing one, and click "OK".
5. The PivotTable Field List will appear on the right side of the Excel window. Arrange the fields as follows:
   • Drag and drop the "Assigned Agent" field to the "Rows" area. This will group the requests by agents.
   • Drag and drop the "Requirement Age" field to the "Values" area. This will display the count of requests for each agent.
6. To filter and sort the requests that are older than 7 days, do the following:
   • Click on the arrow next to the "Requirement Age" field in the "Values" area.
   • Select "Value Filters" and then "Greater Than Or Equal To".
   • In the dialog box, enter "7" and click "OK".
   • Click on the drop-down arrow next to the "Requirement Age" field in the "Values" area again.
   • Choose "Sort Largest to Smallest" to arrange the requests from the oldest to the most recent.
7. You can add additional fields to the rows or columns area based on your reporting requirements. For example, you can add "Creation Date", "Type", and "Requester" to the "Rows" area to provide more detailed information in the pivot table.
8. Customize the pivot table's formatting, layout, and any other settings as needed.

Your pivot table should now display support requests grouped by agents, with requests older than 7 days sorted from oldest to most recent.