Results 1 to 4 of 4

Pivot table-Displaying multiple Row Labels on one line

This is a discussion on Pivot table-Displaying multiple Row Labels on one line within the Excel Questions forums, part of the Question Forums category; I'm trying to have "2000 Central Parkway" display to the right of the "Carrington Park-2990" field, and so on for ...

  1. #1
    Board Regular
    Join Date
    Oct 2008
    Posts
    82

    Default Pivot table-Displaying multiple Row Labels on one line

    I'm trying to have "2000 Central Parkway" display to the right of the "Carrington Park-2990" field, and so on for the other addresses below. I'm stuck. Any ideas? Sorry but I'm a novice at Pivot Tables.



    Sheet3

    AB
    1Region(All)
    2

    3Row Labels
    4AL
    5Midwest
    6Carrington Park-2990
    72000 Central Parkway
    8AR
    9Midwest
    10Avondale-3047
    111812 Reservoir Blvd.
    12Enclave at the Riverfront-3816
    1375 West Riverdrint Drive
    14Ranch at Pinnacle Point-3448
    155900 Stoney Brook
    16Sunset Village-3469
    172611 W. 34th Street
    18AZ
    Excel 2010


    Last edited by Excel Chimp; Sep 21st, 2011 at 11:45 AM.

  2. #2
    Board Regular
    Join Date
    Oct 2008
    Posts
    82

    Default Re: Pivot table-Displaying multiple Row Labels on one line

    I generated the picture from the Mr Excel HTML tool, but it is not displaying the pivot table detail properly.

  3. #3
    Board Regular
    Join Date
    May 2010
    Location
    California
    Posts
    378

    Default Re: Pivot table-Displaying multiple Row Labels on one line

    Without knowing how your data is setup, its hard to know how the pivot is responding to your data. First though, set your pivot table in classic view. To do this, go to Pivot Table Options>Display>Select Classic Pivot Table Layout. Then put your region and address in the Row Labels section. See how that works.

  4. #4
    Board Regular
    Join Date
    Oct 2008
    Posts
    82

    Default Re: Pivot table-Displaying multiple Row Labels on one line

    Thanks for the reply. I think it had to do with the Report Layout. Once I switched this to Tabular View (Pivot Table tools-->Design->Report Layout->Show in Tabular Form) it fixed it.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com