Microsoft Office Tutorials and References
In Depth Information
Table 16-2. Key Properties and Methods of the PivotTable Object
Property/Method
Description
AddDataField(Field, Caption,
Method: This routine adds a data field to a PivotTable.
Function)
Field is a PivotField object associated with the PivotTable.
Caption contains a value that will be used to label the
specified PivotField (optional). Function specifies the
summary function performed on the data field.
CalculatedFields
Method: returns a CalculatedFields collection, which
contains the set of PivotField objects, which are
computed based on other fields in the PivotTable.
ColumnFields
Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as column fields.
ColumnGrand
Property: when True , the PivotTable report displays grand
totals for each column in the PivotTable object.
DataFields
Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as data fields.
DisplayErrorString
Property: when True , any cells with errors will display the
text in the ErrorString property.
DisplayNullString
Property: when True , any cells with null values will display
the text in the NullString property.
ErrorString
Property: contains the text that will be displayed in cells
with errors, if the DisplayErrorString property is True .
Format (format)
Method: sets the PivotTable’s format to one of the
formats specified in XlPivotFormatType . Valid formats are
xlPTClassic , xlPTNone , xlPTReport1 to xlPTReport10 , and
xlPTTable1 to xlPTTable10 .
HiddenFields
Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are not
currently displayed as row, column, page, or data fields.
Name
Property: contains the name of the PivotTable.
NullString
Property: contains the text that will be displayed in cells
with null values when the DisplayNullString property
is True .
PageFields
Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as page fields.
Search JabSto ::




Custom Search