ExcelPivotTableField Properties
From Office Open XML
The ExcelPivotTableField type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | Axis |
Type of axis
|
| Compact |
Compact mode
|
| Grouping |
Grouping settings.
Null if the field has no grouping otherwise ExcelPivotTableFieldNumericGroup or ExcelPivotTableFieldNumericGroup.
|
| IncludeNewItemsInFilter |
A boolean that indicates whether manual filter is in inclusive mode
|
| Index | |
| IsColumnField |
If the field is a column field
|
| IsDataField |
If the field is a datafield
|
| IsPageField |
If the field is a page field.
|
| IsRowField |
If the field is a row field
|
| Items |
Pivottable field Items. Used for grouping.
|
| Name |
Name of the field
|
| Outline |
A boolean that indicates whether the items in this field should be shown in Outline form
|
| PageFieldSettings | |
| ShowAll |
A boolean that indicates whether to show all items for this field
|
| Sort |
The type of sort that is applied to this field
|
| SubTotalFunctions |
Enumeration of the different subtotal operations that can be applied to page, row or column fields
|
| SubtotalTop |
The custom text that is displayed for the subtotals label
|
