Microsoft Office Tutorials and References
In Depth Information
Figure 20-38. LabelRange for Store Type = Company
PivotFields("Store Type"). _
PivotItems("Company").LabelRange.Select
Figure 20-38. LabelRange for Store Type = Company
20.9.3 IsCalculated Property
This property returns True if the pivot item is a calculated item. We discuss calculated items later
in the chapter.
20.9.4 Name, Value, and SourceName Properties
The read-write Name property returns or sets the name of the PivotItem. This is the value that
appears in the label for that item. The Value property is the same as the Name property.
The read-only SourceName property returns the name of the item in the original source data. This
may differ from the value of the Name property if the Name property has been changed.
20.9.5 Position Property
The Position property returns or sets the position of the pivot item. For instance, the code:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type"). _
PivotItems("Franchise").Position
returns the number 2, since Franchise is the second pivot item in the pivot table (see Figure 20-10 . )
Moreover, we can reverse the positions of Company and Franchise by setting the Position of the
Franchise pivot item to 1, as follows:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type"). _
PivotItems("Franchise").Position = 1
20.9.6 RecordCount Property
 
 
Search JabSto ::




Custom Search