Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Next »

Introduced in build 8.3

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

BaseField

The page EW8:PivotTableField.BaseField could not be found.

BaseItemIndex

The page EW8:PivotTableField.BaseItemIndex could not be found.

BaseItemNext

The page EW8:PivotTableField.BaseItemNext could not be found.

BaseItemPrevious

The page EW8:PivotTableField.BaseItemPrevious could not be found.

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.

IsCalculatedField

The page EW8:PivotTableField.IsCalculatedField could not be found.

NumberFormat

Sets or returns the number format string for the PivotTableField.

Position

The page EW8:PivotTableField.Position could not be found.

ShowValueAsType

The page EW8:PivotTableField.ShowValueAsType could not be found.

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.

Methods

Name

Description

SetShowValueAs()

The page EW8:PivotTableField.SetShowValueAs (PivotTableField.ShowValueAsType, SourceField, Int32) could not be found.
  • No labels