Can a query that has subtotal headers be automatically collapsed when the query is run?

Ctrl+Click or Command+Clicking these arrows will collapse all subtotal headers on that specific tier of subtotal headers.

There’s no setting to have a subtotaled header be automatically collapsed when a query is initially run; it always shows each header as expanded, initially. However, to quickly collapse these headers, you can use the following hotkeys to collapse all headers:

  • Ctrl+Click (PC)
  • Command+Click (Mac)