Data not showing on Pivot Table

[la_techie]

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.

[JosephP]

You still have 'fotokem' items in your data (in the hidden rows) and since the pivot table is not case sensitive it just shows the first one it comes across. You need to remove all filters, then replace ALL the items you want changed, and then refresh the data.