Pivot Table Issues

How to Create a Pivot Table to Filter Employees by Supervisor in Spreadsheet

Steven Parker Oct 16, 2026 868 views

Question details

The user needs to create a structured table that allows filtering by a specific supervisor, displaying the relevant employees in rows with their corresponding details in columns.

How to Create a Pivot Table to Filter Employees by Supervisor

Product: Spreadsheet
Device & OS: not provided
Scenario: Organizing an employee roster or HR dataset to dynamically view team members based on their assigned supervisor.
Observed behavior: The user aims to achieve a dynamic grouping state where selecting a supervisor instantly filters the data to show associated employees.

Before you start

Ensure your source data is organized in a tabular layout with clear, unique column headers (e.g., Supervisor, Employee Name, Department) and contains no empty rows or columns within the dataset.

Solution 1Recommended

Use a Pivot Table to Filter and Organize Employee Data

Inserting a Pivot Table is the most efficient way to dynamically filter and restructure your employee dataset without altering the original source data.

A Pivot Table allows you to assign specific data columns to different functional areas such as Filters, Rows, and Columns. By placing the supervisor field into the Filters area, you create a dropdown menu that controls the entire table's display.

Select Your Source Data

Click and drag to highlight your entire dataset, ensuring all column headers are included in the selection.

Insert the Pivot Table

Navigate to the 'Insert' tab on the top ribbon and click 'PivotTable'. Choose whether to place the Pivot Table on a new worksheet or the existing one, then click 'OK'.

Configure the Pivot Table Fields

In the PivotTable Fields pane on the right side of the screen, drag the 'Supervisor' (or 'Category') field into the 'Filters' box.

Organize Rows and Columns

Drag the 'Employee' field into the 'Rows' box so each employee appears on a separate line. Drag any additional employee details (like role or department) into the 'Columns' or 'Values' box as needed.

Apply the Supervisor Filter

Go to the newly created Pivot Table, click the dropdown arrow next to the Supervisor filter at the top, select a specific supervisor, and click 'OK' to display only their related employees.

Use a Pivot Table to Filter and Organize Employee Data

Quick Tip: If you want to view employees for multiple supervisors at once, check the 'Select Multiple Items' box in the filter dropdown menu before making your selections.

Efficient Data Management

Create and Manage Pivot Tables Easily in WPS Spreadsheet

WPS Spreadsheet offers powerful, intuitive Pivot Table capabilities to help you quickly filter, summarize, and analyze complex datasets like employee rosters with just a few clicks.

1. Open Your Data: Launch WPS Spreadsheet and open your employee dataset.
2. Insert PivotTable: Go to the 'Insert' tab and click on the 'PivotTable' icon.
3. Assign Fields: Drag 'Supervisor' to the Filters area, and 'Employee' to the Rows area.
4. Filter Results: Use the filter dropdown located at the top of the Pivot Table to select a supervisor and view their team.

Easily create complex Pivot Tables to filter data by categories such as supervisors.Fully compatible with Microsoft Excel (.xlsx) formats and Pivot Table structures.Free, lightweight, and features a familiar interface with no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Pivot Table not updating when I add new employees?

Pivot Tables do not update automatically when the source data changes. To include new employees, you must right-click anywhere inside the Pivot Table and select 'Refresh', or go to the PivotTable Options tab and click 'Refresh'.

Why are my employee names showing as numbers instead of text?

If you place a text field into the 'Values' area of the PivotTable Fields pane, it defaults to counting the items. To display the actual text (employee names), ensure you drag the Employee field into the 'Rows' or 'Columns' area instead.

Can I filter by supervisor without using a Pivot Table?

Yes. You can use standard data filtering by highlighting your headers, going to the 'Data' tab, and clicking 'Filter'. However, a Pivot Table is recommended if you want to restructure the data display and summarize information simultaneously.

Excel & Data Problems