Export (0) Print
Expand All
Expand Minimize

2.5.104 PivotItemType

Office

The PivotItemType enumeration specifies the type of a pivot item (section 2.2.5.3.3) as specified by a BrtBeginSXVI (section 2.4.263) record, or that specifies the type of a pivot line (section 2.2.5.3.8.3) as specified by a BrtBeginSXLI (section 2.4.240) record.

Name

Value

Meaning

PITDATA

0x00

Specifies no subtotal, no grand total, or no blank line behavior.

PITDEFAULT

0x01

Specifies a subtotal using the aggregation function specified by the data items (section 2.2.5.3.7.5.1) included in this subtotal.

PITSUM

0x02

Specifies a subtotal using the Sum aggregation function.

PITCOUNTA

0x03

Specifies a subtotal using the Count aggregation function.

PITAVG

0x04

Specifies a subtotal using the Average aggregation function.

PITMAX

0x05

Specifies a subtotal using the Maximum aggregation function.

PITMIN

0x06

Specifies a subtotal using the Minimum aggregation function.

PITPRODUCT

0x07

Specifies a subtotal using the Product aggregation function.

PITCOUNT

0x08

Specifies a subtotal using the Count Numbers aggregation function.

PITSTDDEV

0x09

Specifies a subtotal using the Standard Deviation aggregation function.

PITSTDDEVP

0x0A

Specifies a subtotal using the Standard Deviation of a Population aggregation function.

PITVAR

0x0B

Specifies a subtotal using the Variance aggregation function.

PITVARP

0x0C

Specifies a subtotal using the Variance of a Population aggregation function.

PITGRAND

0x0D

Specifies a grand total line.

PITBLANK

0x0E

Specifies a blank line.

Show:
© 2014 Microsoft