Pivot Table Issues

How to Repeat Custom Field Labels in Every PivotTable Row

Khadija Khan Oct 1, 2026 868 views

Question details

The user wants to display custom field values on every row of a PivotTable and understand why the PivotTable alters the original source data's sort order.

How to Repeat Custom Field Labels in Every PivotTable Row

Product: Spreadsheet
Device & OS: not provided
Scenario: Formatting a PivotTable layout to ensure field labels are repeated for better data readability, and troubleshooting unexpected sorting changes.
Observed behavior: Custom field labels only appear once per group instead of on every row, and the PivotTable sorts data by the custom field rather than the original source order.

Before you start

Ensure your PivotTable source data is correctly formatted without blank rows or columns, and verify the original sorting order in your raw data before making layout changes.

Solution 1Recommended

Enable Repeat Item Labels in Field Settings

Use this method to force the PivotTable to display the selected field's label on every single row within its group.

By default, PivotTables group items and only show the label once at the top of the group. Changing the layout to tabular form allows you to repeat these labels.

Open Field Settings

Right-click a value in the specific custom field within your PivotTable and select "Field Settings" from the context menu.

Navigate to Layout & Print

In the Field Settings dialog box, click on the "Layout & Print" tab.

Apply Tabular Form and Repeat Labels

Check the box for "Show item labels in tabular form" and then check the box for "Repeat item labels". Click OK to apply the changes.

Enable Repeat Item Labels in Field Settings

Field-Specific Application: This setting only affects the selected field. If you have multiple fields that need repeated labels, you must apply this setting to each one individually.

Solution 2

Correcting PivotTable Sort Order Preferences

Understand and adjust how PivotTables automatically sort data by row labels rather than preserving your raw data's order.

Efficient Data Analysis

Create and Format PivotTables Easily with WPS Spreadsheet

WPS Spreadsheet provides robust, easy-to-use PivotTable tools to summarize, analyze, and format your data exactly how you need it. You can seamlessly repeat item labels and manage sorting with a familiar interface.

1. Insert a PivotTable: Open your data file in WPS Spreadsheet, select your data range, and go to Insert > PivotTable.
2. Access Field Settings: Right-click any row field in your newly created PivotTable and choose Field Settings.
3. Enable Repeated Labels: Navigate to the Layout & Print tab, check 'Show item labels in tabular form', check 'Repeat item labels', and click OK.

Easily repeat item labels for clean tabular layouts.Advanced sorting and filtering options for complex datasets.Fully compatible with Microsoft Excel (.xlsx) PivotTables.Free and lightweight alternative for powerful data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Repeat item labels' option grayed out or unavailable?

This option is typically only available when the PivotTable layout is set to Tabular Form. Go to the PivotTable Design tab, click Report Layout, and select 'Show in Tabular Form' first to activate the feature.

Can I repeat all item labels for the entire PivotTable at once?

Yes. Instead of doing it field by field, you can go to the PivotTable Design tab, click 'Report Layout', and select 'Repeat All Item Labels' to apply it to all fields in the entire table.

Why did my PivotTable change the sort order of my original data?

PivotTables automatically group, aggregate, and sort data alphabetically or numerically based on the fields you add to the Rows or Columns areas. It does not retain the original row-by-row layout or sort order of your raw data.

How do I turn off repeated item labels?

To turn them off globally, go to the Design tab, click Report Layout, and select 'Do Not Repeat Item Labels'. Alternatively, uncheck the option in the specific Field Settings for individual columns.

Excel & Data Problems