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.

Put Location in the row area
Put all three Late fields in the Column area
Put Item # in the data area, as count of item
Then, double-click on a number in the data area, or in the total, to see
the detail for that number

xgirl wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra. Now when I double click I do get the correct list. But ...
The pivot table is now very unclear. There are a lot of cells with the word
(Blank) and with an "x" and the totals don't look like they are associated
with the late fields. Anyway to change that?

You'd get a better result in the pivot table if your source data had
columns for Location, Item, and Status. In the Status column, enter one
of the Late status options, or leave it blank.

Then, create a pivot table with Location in the Row area, Status in the
column area, and Item count in the data area.

xgirl wrote:
Thank you Debra. Now when I double click I do get the correct list. But ...
The pivot table is now very unclear. There are a lot of cells with the word
(Blank) and with an "x" and the totals don't look like they are associated
with the late fields. Anyway to change that?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Many thanks, that worked perfectly.

You're welcome. I'm glad it helped.

xgirl wrote:
Many thanks, that worked perfectly.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html