Every time I select a field for a pivot table, the PivotTable Fields dialogue box collapses back to its original state.  I’d like to select multiple fields without having to drill to the specific field folder each time.  Is there a setting that controls this?  The data source is an attached database.

​Every time I select a field for a pivot table, the PivotTable Fields dialogue box collapses back to its original state.  I’d like to select multiple fields without having to drill to the specific field folder each time.  Is there a setting that controls this?  The data source is an attached database.  Read More

​