You have got it. You just need to change the layout of the Pivot so that
the Location appears as row instead of Page. Then you can double click
on the row you want and take out the relevant details.

Govind.

xgirl wrote:

I think I've set my table up wrong. I have "Location" in the page field and
then "Count of Late", "Count of Late if not rec'd today" and "Count of Late
if not shipped today" in the data field with nothing in row or column
fields. So I have a very small neat table that gives me the correct totals
but ... well you know the rest. Can you steer me in the right direction.
This is my first attempt at a pivot table. Thanks for your help.