گۇرۇپپىلاش

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

بۇ بۇيرۇقنى زىيارەت قىل…

With cursor placed in a pivot table:

Choose Data - Group and Outline - Group.

Choose Data - Group

On the Data menu of the Data tab, choose Group

Group

F12

باشلا

Specifies the start of the grouping.

Specifies whether to start grouping at the smallest value.

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.

Specifies whether to enter the end value for grouping yourself.

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

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

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

[text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping not found].