Pivot table drilldown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a data table in a sheet with thousands of records. there are about 15
different fields. i created a pivot table to summarize about 5 of the
fields. when i double click the first field to "expand" it and show detail,
i notice that all of the sub fields have all of their detial shown. is there
a way to hide detail for every field in the entire table so that i don't have
to drill down to the smallest detail for every category, and hide detail for
each item. TIA.
 
You can do all the items in each field at the same time:

Check that 'Enable Selection' is turned on (on the PivotTable toolbar,
choose PivotTable>Select -- 'Enable Selection' should be highlighted)

In the column area, point to the top of a field button
When the pointer changes to a black arrow, click to select the field
On the PivotTable toolbar, click the 'Hide Detail' button

Repeat these steps for the remaining fields.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Item Displaying Incorrect Value? 1
Pivot table field list missing 5
Problem if Source field name of pivot table changes 1
Excel How to preserve column fields in a specific order in a pivot table? 2
grouping dates in pivot table: calculated field? 2
Pivot Table Drilldown 3
2007 Pivot table Calculated field misbehaving 1
pivot table - get the average of a field 1

Back
Top