Below is an example excel that I can't get to work correctly. I have 2 different sets of data in 2 different tables each. One set of data I made from scratch and successfully made a Pivot table (from 2 tables) that shows the information in the way I want it to. The other Pivot table that is directly taken from the source material I need "pivoted" will not filter correctly. I do not know why, thanks for any help.
https://drive.google.com/open?id=0BxtnYV7DvofUMFdRV1VjdktFQUU