Explanation

Grouping is especially useful for making large reports easier to read.

Example

Region

Month

Sales

North

January

40,000

North

February

45,000

North

March

48,000

South

January

35,000

South

February

42,000

South

March

46,000

You can group monthly details under each region.

Recommended Workflow

Detailed Data

↓

Add Summary Rows

↓

Group Related Rows/Columns

↓

Create Outline

↓

Collapse/Expand as Required

Important

Grouping does not delete or permanently remove data. It controls how much detail is currently displayed.

Practice

Create a regional sales report with grouped monthly details.