Pivot table in excel 2007 €“ default the data to collapsed?
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? |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com