+ Reply to Thread
Results 1 to 4 of 4

All Row Label doesn't display in Pivot ( Excel 2010 )

  1. #1
    Forum Contributor
    Join Date
    06-12-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    153

    All Row Label doesn't display in Pivot ( Excel 2010 )

    I got 7300 entries, while I have excel displaying only 2400. Also, everytime create pivot for the same data, the count keeps changing i.e. 2439, 2500..

    Kindly Advise

    Also, the same colum while droped into value, displays a count of 7300

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: All Row Label doesn't display in Pivot ( Excel 2010 )

    Please attach a sample of your workbook so we can use your own data to work on possible solutions. Remember to remove or replace sensitive data before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Forum Contributor
    Join Date
    06-12-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    153

    Re: All Row Label doesn't display in Pivot ( Excel 2010 )

    thanks for the response.. PFA sample document
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: All Row Label doesn't display in Pivot ( Excel 2010 )

    Your pivot table does include all data from the dump tab. I have added a count field so you can see in the total that it refers to 7,319 records.
    Attached Files Attached Files

+ 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. [SOLVED] Pivot Table selection doesn't show Label in drop down?
    By Dude to Excel Dude in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2014, 02:00 PM
  2. Display an active pivot table in excel 2010 userform
    By Tazyote in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2014, 11:14 PM
  3. Display only the mimum row label in a pivot table
    By shepherdc2814 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2013, 07:45 PM
  4. Main Label in Pivot Table - Doesn't Fill - Need to use Formula - Help?
    By tarnold99 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2010, 05:53 PM
  5. [SOLVED] Display Row label covering multiple lines in Excel Pivot Table
    By Marty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2006, 09:00 AM

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