PivotDataField Members
In This Article
#Properties
Name | Description |
---|---|
Base |
Returns the base field used by the “Show Values As” calculation option applied to the data field. |
Base |
Returns the base item used by the “Show Values As” calculation option applied to the data field. |
Base |
Returns the type of the base item used by the “Show Values As” calculation option applied to the data field. |
Field |
Provides access to the underlying pivot field referenced by the current object.
Inherited from Pivot |
Name | Gets or sets the name of the data field. |
Number |
Specifies a number format (in the invariant culture) used to display summary values within the data field. |
Number |
Specifies a local number format used to display summary values within the data field. |
Position |
Returns or specifies the field position in the collection that corresponds to the Pivot |
Show |
Gets the type of calculation applied to the data field in addition to the actual value of the field. |
Summarize |
Gets or sets the summary function used to calculate values in the data field. |
#Methods
Name | Description |
---|---|
Get |
Retrieves summary data for the specified items of the pivot table. |
Move |
Moves the field to the next position within the collection which represents the Pivot |
Move |
Moves the field to the first position within the collection which represents the Pivot |
Move |
Moves the field to the last position within the collection which represents the Pivot |
Move |
Moves the field to the previous position within the collection which represents the Pivot |
Show |
Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report. |
Show |
Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report. |
Show |
Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report. |
Show |
Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report. |
Show |
Shows summary values in the data field “as-is”, with no additional calculation applied to the actual value of the field. |
See Also