Pivot Table Drilldown

[Guest]

I've created a pivot table from a query. The data numbers are displayed,
however, I cannot drilldown to the underlying names that corresponds to the
numbers. How can I view the names?

 

[Ed Robichaud]

Pretty sure that there is no direct way to do what you seek as a pivot
table/cross-tab is really a "totals" query run from multiple perspectives.
Try a simple totals query based on part of your pivot table (i.e.,
[Name]-group by; [Sales]-sum) to view more info than just the totals by
total shown in a pivot table.
-Ed