View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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