Grupēšana

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

Lai piekļūtu šai komandai...

With cursor placed in a pivot table:

From the menu bar:

Choose Data - Group and Outline - Group.

From the tabbed interface:

Choose Data - Group

On the Data menu of the Data tab, choose Group

From toolbars:

Icon Group

Group

From the keyboard:

F12


Sākums

Specifies the start of the grouping.

Automātiski

Specifies whether to start grouping at the smallest value.

Manually at

Specifies whether to enter the start value for grouping yourself.

Beigas

Specifies the end of the grouping.

Automātiski

Specifies whether to end grouping at the largest value.

Manually at

Specifies whether to enter the end value for grouping yourself.

Grupēt pēc

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

Dienu skaits

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

Intervāli

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

Please support us!