+ Reply to Thread
Results 1 to 2 of 2

Pivot Table does not show all values

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

    Pivot Table does not show all values

    Before you ask. Yes, I did refresh the table and yes, I did reconfirm the source for the pivot tables.

    Unfortunately due to the large volume of proprietary data, I can't post the workbook. It would take days to desensitize the data. The best I can do is pictures. I have a picture of all the rows in the table and a picture of the filter based on the first row. IPHONE X is missing.

    I have a pivot table that is build off an Excel table. I set the filer values on the table using vba. In this case the table has the name of 6 models. The pivot filter shows only 5 of them. I've seen this behavior before. No matter what I do, short of creating a new pivot table, I can't get the table to acknowledge the 6th model.

    It is not the last in the table. I reconfirmed the table range.

    Has anyone else seen this problem? A web search has not been fruitful.
    Attached Images Attached Images
    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.

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

    Re: Pivot Table does not show all values

    I found a work-around. Make another table in the same format as the original. Switch the source to it, then switch the source back.

+ 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. Show/Filter top values in a pivot table
    By spangpang in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-14-2013, 07:39 AM
  2. [SOLVED] How do i show repeated values (Pivot table)
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 11-08-2012, 09:27 AM
  3. Why do identical values show up twice in Pivot Table?
    By desperatepivot in forum Excel General
    Replies: 5
    Last Post: 07-12-2011, 05:58 AM
  4. Pivot table - show values as
    By vesapo in forum Excel General
    Replies: 11
    Last Post: 11-29-2010, 11:55 AM
  5. Pivot Table to show row values
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 10:06 AM
  6. [SOLVED] Show values only in a pivot table
    By ymze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2005, 03:05 PM
  7. [SOLVED] Do not show rows with no values in Pivot Table
    By Mark in forum Excel General
    Replies: 0
    Last Post: 04-19-2005, 02:06 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