Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

The PivotTableField 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

DisplayName

Sets or returns the displayed name of the PivotTable field.

DisplaySubtotalsAtTop

Sets or returns whether or not the subtotals for each group should be displayed at the top or the bottom.

FieldType

The PivotTableField.FieldType enumeration contains the field types available for a PivotTableField.

IsValuesLabel

Returns whether or not the field is a auto generated Values Label.  This is only applicable for row labels and column labels.

NumberFormat

Sets or returns the number format string for the PivotTableField.

ShowValueAs

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.

SortOptions

The SortOptions class contains all of the sorting options for a PivotTableField.

SummarizeBy

Sets or returns the type of calculation used to summarize a data field. The available types are determined by PivotTableField.SummarizeByType.

SummarizeByType

The SummarizeByType class contains the Excel value field summarize by types supported by ExcelWriter.

Source

Returns the SourceField that was used to build the PivotTableField in the PivotTable.
  • No labels