Grouping

Grouping pivot tables displays the Grouping dialog for either values or dates.

Щоб скористатися цією командою…

Choose Data - Group and Outline - Group.


Початок

Specifies the start of the grouping.

Автоматично

Specifies whether to start grouping at the smallest value.

Manually at

Specifies whether to enter the start value for grouping yourself.

Кінець

Specifies the end of the grouping.

Автоматично

Specifies whether to end grouping at the largest value.

Manually at

Specifies whether to enter the end value for grouping yourself.

Group by

Specifies the value range by which every group's limits are calculated.

Number of days

In the case of grouping date values, specifies the number of days to group by.

Intervals

In the case of grouping date values, specifies the intervals to group by.