Grouped rows expand when filtering
 

Hello,

I have a worksheet with grouped rows. When I use a filter on a particular
variable, and then want to see the whole worksheet, all rows are ungrouped.
Is there a way to always display rows grouped unless when filtering on a
particular variable (when all rows relating to that variable are expanded)?

thank you.