Message-ID: <740419731.7875.1711624642377.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7874_632137920.1711624642377" ------=_Part_7874_632137920.1711624642377 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

The  PivotTableField represents a single field in a Pivot Table.&nb= sp; This can be a row label, column label, data field (or value field) or a= page field (or report filter).  To get a=20 PivotTableField object, use a=20 FieldCollection.=20
C#
=20
 public sealed class PivotTableField
=20
=20
vb.net
=20
Public NotInheritable Class PivotTableField
=20

Properties

Name

Description

DisplayName

Sets or returns the displayed name of the PivotT= able 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 gener= ated Values Label.  This is only applicable for row labels and column = labels.

NumberFormat

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

ShowValu= eAs

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.

SortOpti= ons

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.Summarize= ByType.

SummarizeByType

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

<= /td>

Source

Returns the SourceField that was used to build the PivotTableField in the PivotTable.<= /td>
------=_Part_7874_632137920.1711624642377--