It does generate a new worksheet but it lists all the items for the location.
Example: Location 10 has 2 late items. The pivot table shows a total of 2
for "Count of Late" but when I double click it, it lists all 10 items. I
would like it to list only the late.

"Govind" wrote:

When you double click on a total, does it generate a new worksheet? If
yes, it is listing out all the data, which the total field is made up
of. The other possibility is that you are unhiding a summary field.

Govind.

xgirl wrote:

Hello, I have pivot table based on data that identifies an item as "late"
"late if not rec'd today" and "late if not shipped today". The totol lists
the correct number from each category for a location but when I double click
on that total I get a list of every entry for that location, not just the
late etc. What am I doing wrong?