+ Reply to Thread
Results 1 to 4 of 4

Row labels not showing correctly in pivot table

  1. #1
    Registered User
    Join Date
    02-16-2016
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    2

    Row labels not showing correctly in pivot table

    Hello,

    I need to create a pivot table showing whether or not customers used various types of promotions during specific fiscal quarters. My Column headers are the quarters and my rows are to be the types of promotions. I have made sure that every column in the source data has a header. The Fiscal Quarters are showing up just fine across the top as columns - their labels show exactly as they do in the source data.

    However, the rows, which are supposed to be a series of promotion names do not show the correct row labels. Let's say one of the discounts is Bundling, another is Renewal, and one is Bulk. Each of these promotions has a column in the source data with the name of each promotion as the column header. The data under each row is just a Y or a N, indicating whether or not that promotion was used. These promotions columns are formatted as General. When I select these three items in the Field table list and move them to Rows, I would expect a new row to show up with each of these names (which is how they appear in the field list). But, instead, I get this:

    Row labels: (dashes added to indicate indentation. I inserted manual spaces, but once I posted this thread, they all aligned left.
    N
    -N
    --N
    --Y
    -Y
    --N
    Y
    -N
    --N

    Unfortunately, I cannot provide a copy of the sheet because it contains confidential company information. A couple other odd bits of info: If I hover over any of these N's or Y's, they show the correct row label in parenthesis - so if I hover over that first N, I see N(Bundling). When I follow Microsoft's online instructions for changing the row label names, the dialogue box that comes up shows the correct name already in place. Any ideas?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,423

    Re: Row labels not showing correctly in pivot table

    You can't rename a row or column header to a name that is part of the data, but you can easily type in the same name with a leading or trailing space.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    02-16-2016
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    2

    Re: Row labels not showing correctly in pivot table

    Hello,

    Thank you for taking the time to respond, but your answer doesn't address my issue. I am not trying to rename a row or column header to a name that is part of the data. Please review my description in my original post and you will see that the problem is that Excel is not using the already existing column headers from the source data. Instead, it is using (seemingly random) data from the cells below the headers. To make that even more odd, it is only doing it for certain columns in the spreadsheet. For all other columns, the labels are showing up in the pivot table just as they do in the source data and the field list, as you would expect.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,395

    Re: Row labels not showing correctly in pivot table

    Row / Column fields show the values of the fields, not the names. You will only see the field names in tabular layout and they will be at the top.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  2. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  3. Pivot Table - Show Row labels horizontally (Not as Column labels)
    By Catsup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2014, 01:15 PM
  4. Replies: 7
    Last Post: 07-22-2013, 11:29 AM
  5. How to set up a Pivot Table correctly
    By Cavrunin in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-08-2013, 01:04 PM
  6. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  7. Replies: 5
    Last Post: 07-05-2005, 03:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1