Microsoft Office Tutorials and References
In Depth Information
Table 16-5. Key Properties and Methods of the PivotField Object
Property/Method
Description
DragToColumn
Property: when False , means that the field cannot be dragged
to the column area in the PivotTable.
DragToData
Property: when False , means that the field can’t be dragged to
the data area in the PivotTable.
DragToHide
Property: when False , means that the field can’t be dragged
away from the PivotTable.
DragToPage
Property: when False , means that the field can’t be dragged to
the page area of the PivotTable.
DragToRow
Property: when False , means that the field cannot be dragged
to the row area in the PivotTable.
LayoutForm
Property: contains the way that PivotTable items appear.
xlTabular implies table format; xlOutline specifies outline
format.
MemoryUsed
Property (read-only): returns the number of bytes used by the
current PivotField object.
Name
Property: contains the name of the PivotField object.
NumberFormat
Property: contains the formatting specifications that will be
used to display the information from the PivotField object.
Applies only to fields used in the data area of the PivotTable.
Orientation
Property: contains the location of the field in a PivotTable as
specified by the XlPivotFieldOrientation type ( xlColumnField ,
xlDataField , xlHidden , xlPageField , or xlRowField ).
PivotItems
Method: returns the collection of PivotItems representing the
individual items within a particular field.
Position
Property: contains the relative position of the field within its
orientation.
ShowAllItems
Property: when True , means that all items in the PivotTable
report will be displayed even if they don’t contain summary
data.
Value
Property: contains the name of the specified field in the
PivotTable report.
Search JabSto ::




Custom Search