+ 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
    2013 / 2016 / 365
    Posts
    6,981

    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
    2013 / 2016 / 365
    Posts
    6,981

    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)

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