Results 1 to 3 of 3

Thread: How to repeat row labels on Pivot Table in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    23

    How to repeat row labels on Pivot Table in Microsoft Excel

    1. In a pivot table with multiple "row fields" I need the data label for each row field to repeat on each and every line instead of grouping them with blank cells between each unique row field.
    2. Also, I have multiple data items as well. If the value is zero or blank, is there a way to make that value for the person to not show up at all instead of a line with a blank or zero value?

    I know this data would be better managed in Access but our company does not let us use that program.

  2. #2
    Join Date
    Jul 2011
    Posts
    634

    Re: How to repeat row labels on Pivot Table in Microsoft Excel

    There are certain assumptions from my side :
    1. Pivot tables don't work that way. You could convert it to text and fill those cells, though.
    2. I am not sure you can hide the 0 values. But after you convert it to text, you can do anything you want.

    Sometimes I do this to hide/show what I want. I'll insert another column and create a formula that determines if that row should be shown or hidden. So try this out =if(a2=0,"Hide","show") then use that field in the page field of the pivot table. I can choose to see only the "Shows".

  3. #3
    Join Date
    Aug 2011
    Posts
    540

    Re: How to repeat row labels on Pivot Table in Microsoft Excel

    Look in the PivotTable Options tab layout and format. There is an option "Automatically adjust column widths on update 'of mW which is checked by default. Take the hook to get out and test the whole thing.

    Repeat item labels in a PivotTable report

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 12:09 PM
  2. I need help to lock pivot table header in Microsoft Excel
    By cupid! in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 05:01 PM
  3. How to get side by side row labels in Excel 2007 Pivot Table
    By The-Farmer in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 06:01 PM
  4. How to move the total column in Microsoft Excel Pivot Table
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 05:55 PM
  5. Replies: 5
    Last Post: 24-01-2012, 05:02 PM

Tags for this Thread

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
  •  
Page generated in 1,711,724,377.28871 seconds with 17 queries