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.
Bookmarks