.
Introduced in build 8.4
Description
ThePivotTableField represents a single field in a Pivot Table. This can be a row label, column label, data field (or value field) or a page field (or report filter). To get a PivotTableField object, use a FieldCollection.
C#
vb.net
Properties
Name | Description |
|---|---|
| Sets or returns the displayed name of the PivotTable field. | |
| Sets or returns whether or not the subtotals for each group should be displayed at the top or the bottom. | |
The PivotTableField.FieldType enumeration contains the field types available for a PivotTableField. | |
| Returns whether or not the field is a auto generated Values Label. This is only applicable for row labels and column labels. | |
Sets or returns the number format string for the PivotTableField. | |
The ShowValueAs class contains the options for showing the value of a DataField. It is equivalent to the Show Values As tab in DataField settings in Excel. | |
The SortOptions class contains all of the sorting options for a PivotTableField. | |
Sets or returns the type of calculation used to summarize a data field. The available types are determined by PivotTableField.SummarizeByType. | |
|
The | |
Returns the SourceField that was used to build the PivotTableField in the PivotTable. |