Share via

need help with pivot table fields

Anonymous
2025-02-12T23:16:13+00:00

i have a pivot table showing the labels below in the row fields and another pivot with the same information in the row fields but they're displayed differently. i prefer to have the dates stacked above the sites and was able to show in one table but not another. please see below:

I like this display:

I want to make this display the same as above, with the dates stacked above the location.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-13T16:33:54+00:00

    perfect!!! thank you!

    Was this answer helpful?

    0 comments
  2. Ashish Mathur 102K Reputation points Volunteer Moderator
    2025-02-12T23:48:18+00:00

    Hi,

    Switch to Compact View under Report layout.

    Was this answer helpful?

    0 comments