Spire.XLS API

PivotDataField Class

Represents a data field in a pivot table, which is used to perform aggregate calculations such as sum, average, count, etc.

Inheritance Hierarchy

System Object
Spire.Xls.Core.Spreadsheet.PivotTables PivotDataField

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public class PivotDataField : IPivotDataField, 
	ICloneParent

Public Class PivotDataField
	Implements IPivotDataField, ICloneParent

public ref class PivotDataField : IPivotDataField, 
	ICloneParent

type PivotDataField =
class
interface IPivotDataField
interface ICloneParent
end

The PivotDataField type exposes the following members.

Properties

	Name	Description
	BaseField	Gets or sets the base field.
	BaseItem	Gets or sets the base item.
	CustomName	Gets/sets pivot field custom name.
	Name	Gets / sets name of the data field.
	ShowDataAs	Gets or sets the show data as.
	Subtotal	Gets/ sets subtotal function used for data field.

Methods

	Name	Description
	Clone	Creates and returns a copy of the specified object.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)