+ Reply to Thread
Results 1 to 3 of 3

Err... What!?! Many Pivot Tables, Same Data, 1 Issue

  1. #1
    Registered User
    Join Date
    12-18-2015
    Location
    irvine
    MS-Off Ver
    2010
    Posts
    2

    Err... What!?! Many Pivot Tables, Same Data, 1 Issue

    I am experiencing a strange issue with just one out of several pivot tables, all using the same data source.

    In just this one particular pivot table, just one label is missing and I have no idea why... because it shows up on all the other pivot tables.

    Here is a screen of the sample data:
    jluw0Qf.png

    Notice under product class we have typical categories (head wear, bottoms, etc).
    In my pivot table, I am having it ordered by product class and just "bottom" seems to have disappeared (row 6, Col B)...
    kafNDkC.png



    All my other pivot tables are fine and have the same configuration/settings... what is the deal.
    sd8aN3a.png
    Last edited by jonathantkids; 06-08-2016 at 11:07 PM. Reason: typo typo

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Err... What!?! Many Pivot Tables, Same Data, 1 Issue

    can only assume the pivot tables are setup with different fields and one of those fields conflicts and spits out another subset of data
    the images are so small i cant see any proper detail without playing to see its guesstimate at best
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: Err... What!?! Many Pivot Tables, Same Data, 1 Issue

    The most likely explanation is simply that you typed over that cell with a space or pressed delete. You can simply retype the correct value there.

+ 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. Subtotal Issue in Pivot Tables Please Help!
    By alesha711 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-06-2016, 11:08 AM
  2. Data validation allowing multiple choices - issue with Pivot tables
    By AnnieParadis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2016, 10:29 AM
  3. Issue with creating pivot tables
    By nobita123 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-17-2015, 09:24 AM
  4. Pivot Tables - Issue
    By kingcordova in forum Excel General
    Replies: 1
    Last Post: 07-12-2012, 11:33 PM
  5. pivot tables issue
    By obasileus in forum Excel General
    Replies: 1
    Last Post: 09-11-2010, 11:50 AM
  6. Complex issue involving pivot tables, and updating data
    By Allieanne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2009, 05:16 PM
  7. issue with pivot-tables
    By AmyTaylor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1