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.