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.