Pivot Table Issues

How to Show Dates Above Sites in an Excel PivotTable

Amos Gikunda Sep 27, 2026 869 views

Question details

The user wants to format a PivotTable so that date fields are displayed vertically above site or location names within the row fields.

How to Show Dates Above Sites in an Excel PivotTable

Product: Excel
Device & OS: not provided
Scenario: Customizing the layout of an existing PivotTable to improve data readability and hierarchical display.
Observed behavior: The current PivotTable displays row fields in a side-by-side or separated layout, and the user needs them arranged in a compact, stacked format with dates on top.

Before you start

Ensure that your PivotTable Field List is open and that both the 'Date' and 'Site' fields are added to the Rows area, with the 'Date' field placed directly above the 'Site' field.

Solution 1Recommended

Change PivotTable Report Layout to Compact Form

Switching the PivotTable to Compact Form is the standard method to stack multiple row fields (like Dates and Sites) into a single column, creating a clean hierarchical view.

By default, Excel may apply different report layouts depending on how the PivotTable was created. The 'Compact Form' layout is specifically designed to keep related row fields in one column, indenting the secondary items beneath the primary items.

Select the PivotTable

Click any cell inside your existing PivotTable to activate the PivotTable Tools on the top ribbon.

Navigate to the Design Tab

Look at the top Excel ribbon and click on the 'Design' tab located under PivotTable Tools.

Apply Compact Form Layout

Click on 'Report Layout' in the Layout group on the left side of the ribbon, then select 'Show in Compact Form' from the drop-down menu.

Change PivotTable Report Layout to Compact Form

Field Order Verification: If the Site appears above the Date after applying Compact Form, simply drag the Date field above the Site field in the 'Rows' box of your PivotTable Fields pane.

Advanced Data Analysis

Create and Format PivotTables Easily in WPS Spreadsheet

WPS Spreadsheet offers a robust, highly compatible PivotTable feature. You can effortlessly adjust report layouts, apply Compact Form, and organize complex data hierarchies just as you would in Microsoft Excel.

1. Insert PivotTable: Open your data file in WPS Spreadsheet, select your dataset, and go to Insert > PivotTable.
2. Arrange Row Fields: In the PivotTable Field List, drag your Date field into the Rows area, followed by the Site field directly below it.
3. Adjust the Layout: Click on the PivotTable, navigate to the PivotTable Analyze or Design tab, select Report Layout, and choose 'Show in Compact Form'.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files with 100% PivotTable compatibility.Easily switch between Compact, Outline, and Tabular report layouts to suit your presentation needs.Free, lightweight, and features a familiar user interface that requires no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my site names appearing in a separate column next to the dates?

This happens when your PivotTable is set to 'Tabular Form' or 'Outline Form'. To stack them in the same column, you must change the Report Layout to 'Compact Form' via the Design tab.

How do I ensure the date acts as the parent category?

The hierarchy is determined by the order of fields in the 'Rows' section of the PivotTable Field List. Make sure the 'Date' field is placed at the top, above the 'Site' field.

Can I group the dates by months or years instead of individual days?

Yes. Right-click any date cell in your PivotTable, select 'Group', and choose the desired timeframes (like Months, Quarters, or Years). This will automatically group your dates above the site names based on the selected periods.

Excel & Data Problems