I have a list of data with the following columns (Location, Item #, Late,
Late if not rec'd today, Late if not shipped today). The last three have an
"x" to indicate status and there are several blanks. I created a pivot table
that had Location in the Page field and Count if Late, Count if Late if not
rec'd today, Count if not shipped today in the data field. My pivot table is
accurate but when I double click on a total for say Late, I get a full list
of all items for that location, not just the late. I tried putting location
in the Row field but got the same result. I want the user to be able to
double click on the Late total and get a new spreadsheet with only those
marked with an x in the late column.

When I move things around I end up getting a pivot table with a bunch of
cells with the word (Blank) in them and sometimes the data is not correct.
Can someone help me set this up properly? This is my first pivot table.