Message-ID: <1045949199.9351.1711689189528.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9350_1338869495.1711689189528" ------=_Part_9350_1338869495.1711689189528 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html PivotTableField

PivotTableField

Introduced in build 8.4

=20

Description

=20

The PivotTableField re= presents a single field in a Pivot Table.  This can be a row label, co= lumn label, data field (or value field) or a page field (or report filter).=   To get a PivotTableField object, use a FieldCollection.

=20
C#
=20
 public sealed class PivotTableField
=20
=20
vb.net
=20
Public NotInheritable Class PivotTableField
=20
=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

DisplayName

Sets or returns the displayed name of the Pivot= Table field.

DisplaySubtotalsAtTop

Sets or returns whether or not the subtotals fo= r 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 gene= rated Values Label.  This is only applicable for row labels and column= labels.

NumberFormat

Sets or returns the number format string for th= e PivotTableField= .

ShowVal= ueAs

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.

SortOpt= ions

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.Summariz= eByType.

SummarizeByType

The SummarizeByType class conta= ins the Excel value field summarize by types supported by ExcelWriter.

=

Source

Returns the SourceField that was used to build the PivotTableField in the PivotTable.=
------=_Part_9350_1338869495.1711689189528--