Results 1 to 2 of 2

Data not showing on Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Beverly Hills, CA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Data not showing on Pivot Table

    Please anyone can help me?

    So, I ran a report with all this data in it, deleted several unnecessary columns and under the “Labels” column (see file attached to this thread), I have changed some data, like for example:
    - from “dadc” to “DADC”
    - from “pbad=n/a, techmont” to “Techmont”
    - and from “fotokem” to “Fotokem” (by using “Find and Replace”).
    Here is the issue I’m having. After manipulating the data as I described above, I want to create a pivot table and once I’m on the Pivot Table page, drag “Labels” (Under “Pivot Table Field List”) to the “Row Labels” field.


    However, when I try to filter “Labels”, I do not see a few of the labels I have previously added like “Technicolor” and “Fotokem” (not in the format I added/edited, with the 1st letter capitalized). Basically some of the info shows and some just don’t. Why is that happening and how can I fix it?
    I tried refreshing everything as I work to no avail.

    Please let me know if you need any more info. I have attached the document here.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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