Set the Group Span for a Column

When columns are grouped, you can choose how often to show column names by changing the group spanning.

For example, when country or region and city are both grouped, you can choose to show the country or region name each time

  • the country or region changes, by spanning Country or Region by Country or Region
  • the city changes, by spanning Country or Region by City
  • there is a new record, by specifying no spanning

Spanning one grouped column by another column is helpful if the second column contains many items.

Procedure

  1. Click the column that will span the other column(s).
  2. Click the Show properties icon Show properties icon, and In the Properties pane, set the Group span property to the column to span.