I often use several levels of grouping to organize data. Although there are options to open or close all the groups at once, I often want to open only the top n groups but leave the bottom one closed. This is especially helpful when I am using Page and Column summaries to calculate data. I can do this by hand, but new entries always cause the the groups to open again. It would be helpful if the Advanced Grouping dialog box contained an option where you could specify whether the group should be open or closed by default much in the same way you can choose ascending or descending sort orders.
Advanced Grouping Options: Default Open/Closed Setting for Each Group