I have a pivot table in excel 2007 that is based on an external data source.
Assume the pivot table is arranged as the following: Sales by country,
region (of the country), by state, then county within the state.
I want a pivot table to extract the data and display a summarized value by
country with the ability to expand the segments as needed.
For example display sales by Canada, Mexico, USA. Then from that a user
will expand a country to display sales by region. Then expand a region to
display sales by state, then allow expansion to display by county.
As the report is run, the data should be presented in summary based on
country (for example Canada, Mexico, US)
Currently, after the data is refreshed, all columns are expanded showing a
very detailed report rather than a very summary report allowing the ability
to expand as needed. Currently, I need to collapse the columns before
presenting the data.
So€¦ How do I get a Pivot table to default certain columns as collapsed,
rather than expanded?