How to collapse all - to + on loading a pivot table

Question & Answer
,
1

Is there a simple way or default setting such that when a pivot table is loaded up, all groups are set to collapse mode? Thanks.

2

Please use the Field Well and Choose Collapse or Right-Click on the Section, then Choose Collapse. Make sure AutoSave is On. Attached is the screenshot.

Screen Shot 2022-12-16 at 4.36.32 PM
Screen Shot 2022-12-16 at 4.36.32 PM903×647 66.8 KB

2 Likes