Hópun

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

Til að nálgast þessa skipun...

Choose Data - Group and Outline - Group.


Ræsa

Specifies the start of the grouping.

Sjálfvirkt

Specifies whether to start grouping at the smallest value.

Handvirkt þann

Specifies whether to enter the start value for grouping yourself.

Enda

Specifies the end of the grouping.

Sjálfvirkt

Specifies whether to end grouping at the largest value.

Handvirkt þann

Specifies whether to enter the end value for grouping yourself.

Flokka eftir

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

Fjöldi daga

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

Tíðni

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