Microsoft Office Tutorials and References
In Depth Information
20.5.1.7 VisibleFields property
The RowFields property returns the collection of all row fields, using the syntax:
PivotTableObject .RowFields
Alternatively, we can return selected row fields using the syntax:
PivotTableObject .RowFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.7 VisibleFields property
The VisibleFields property returns the collection of all visible fields, using the syntax:
PivotTableObject .VisibleFields
Alternatively, we can return selected visible fields using the syntax:
PivotTableObject .VisibleFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.2 Totals-Related Members
The PivotTable object has two properties that affect the display of totals.
ColumnGrand property (R/W Boolean)
When this property is True , the PivotTable shows grand column totals.
RowGrand property (R/W Boolean)
When this property is True , the PivotTable shows grand row totals.
To illustrate, referring to the pivot table in Figure 20-6 , the code:
ActiveSheet.PivotTables("Sales&Trans"). _
ColumnGrand = False
ActiveSheet.PivotTables("Sales&Trans"). _
RowGrand = False
produces the pivot table in Figure 20-9 , with no grand totals.
Figure 20-9. No grand totals
 
 
Search JabSto ::




Custom Search