Pivot Table Issues

Create a WPS Spreadsheets PivotTable Grouped by Agent and Filter Requests Older Than 7 Days

Elise Williams Nov 13, 2026 868 views

Question details

The user needs to create a PivotTable from a support-request report that groups records by assigned agent, shows request details, filters requests older than seven days, and sorts them from oldest to newest.

Create a WPS Spreadsheets PivotTable Grouped by Agent and Filter Requests Older Than 7 Days

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: A support-request report must show Creation Date, Type, Requester, Assigned Agent, Requirement Type, and Age, grouped by agent and sorted from oldest to newest.
Observed behavior: The report should list only requests older than seven days, grouped by agent and sorted by Creation Date ascending.

Before you start

Open the support-request workbook in WPS Spreadsheets and confirm the source table contains the columns Creation Date, Type, Requester, Assigned Agent, Requirement Type, and Age. Make sure all Creation Date values are stored as real dates, not text, so filtering and sorting behave correctly.

Solution 1Recommended

Use a PivotTable Date Filter to Show Requests Older Than Seven Days

Best for a quick interactive report when you can enter the cutoff date manually.

This method keeps the original source table unchanged and uses the PivotTable date filter to limit records before a chosen cutoff.

Open the PivotTable creation dialog

Select any cell in the source table, go to the Insert tab, and click PivotTable.

Add agent and request details to rows

In the PivotTable Field List, drag Assigned Agent to the Rows area, then drag Creation Date, Type, Requester, Requirement Type, and Age below it.

Filter creation dates before the seven-day cutoff

Right-click any date under Creation Date in the PivotTable, choose Filter > Date Filters > Before, and select the date that is seven days before today.

Sort oldest to newest

Right-click any Creation Date value in the PivotTable, choose Sort, and select Sort Oldest to Newest.

Switch to tabular layout

Select the PivotTable, go to the Design tab, click Report Layout, and choose Show in Tabular Form.

Use a PivotTable Date Filter to Show Requests Older Than Seven Days

Date filter is not automatic: This date filter uses the date you choose. If you need the report to always calculate the last seven days, use the helper-column method below or refresh and update the filter.

Solution 2

Add a Dynamic Helper Column for Requests Older Than Seven Days

Use this method when the report must always recalculate the seven-day window automatically.

Create a Seven-Day Filtered Agent PivotTable with WPS Spreadsheets

WPS Spreadsheets gives you the same PivotTable workflow as Microsoft Excel: add Assigned Agent and request details to Rows, apply a date or helper filter for records older than seven days, sort oldest to newest, and present the report in tabular form—all in a free, lightweight Office suite.

1. Prepare and select the source data: Open the support-request workbook in WPS Spreadsheets, click any cell in the source table, and go to Insert > PivotTable.
2. Build the agent-based report: Drag Assigned Agent to Rows, then add Creation Date, Type, Requester, Requirement Type, and Age as additional row fields.
3. Apply the seven-day filter and sort: Use a Creation Date date filter or a helper column filter to keep only records older than seven days, then sort Creation Date oldest to newest.
4. Format the report: On the Design tab, click Report Layout and choose Show in Tabular Form to display each field in its own column.

Group support requests by assigned agent using the familiar PivotTable field listFilter and sort requests older than seven days directly in WPS SpreadsheetsOpen, edit, and save .xlsx workbooks with full Microsoft Excel compatibilityUse a free, lightweight Office suite with a familiar tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

How do I group support requests by assigned agent in WPS Spreadsheets?

Select the source table, click Insert > PivotTable, then drag Assigned Agent to the Rows area. Add Creation Date, Type, Requester, Requirement Type, and Age below Assigned Agent to create the detailed agent grouping.

How do I show only PivotTable dates older than seven days?

If Creation Date is in the Rows area, right-click a date and choose Filter > Date Filters > Before, then set the cutoff date to seven days ago. For an automatically updating report, add a helper column with =IF([@Creation Date]<TODAY()-7,"Yes","No") and filter it on Yes.

How do I sort the PivotTable from oldest to newest?

Right-click a date under Creation Date in the PivotTable and choose Sort > Sort Oldest to Newest. If the dates are grouped automatically, remove the grouping or sort at the date field level.

How do I display the PivotTable in columns instead of the compact layout?

Click the PivotTable, go to Design > Report Layout, and choose Show in Tabular Form. You can also enable Repeat All Item Labels if you want agent names repeated on each row.

Excel & Data Problems