GetPivotData Method
Returns a Range object with information about a data item in a PivotTable report.
expression.GetPivotData(DataField, Field1, Item1, Field2, Item2, Field3, Item3, Field4, Item4, Field5, Item5, Field6, Item6, Field7, Item7, Field8, Item8, Field9, Item9, Field10, Item10, Field11, Item11, Field12, Item12, Field13, Item13, Field14, Item14, Field15)
expression Required. An expression that returns one of the objects in the Applies To list.
DataField Optional Variant. The name of the field containing the data for the PivotTable.
Field1 Optional Variant. The name of a column or row field in the PivotTable report.
Item1 Optional Variant. The name of an item in Field1.
Field2 Optional Variant. The name of a column or row field in the PivotTable report.
Item2 Optional Variant. The name of an item in Field2.
Field3 Optional Variant. The name of a column or row field in the PivotTable report.
Item3 Optional Variant. The name of an item in Field3.
Field4 Optional Variant. The name of a column or row field in the PivotTable report.
Item4 Optional Variant. The name of an item in Field4.
Field5 Optional Variant. The name of a column or row field in the PivotTable report.
Item5 Optional Variant. The name of an item in Field5.
Field6 Optional Variant. The name of a column or row field in the PivotTable report.
Item6 Optional Variant. The name of an item in Field6.
Field7 Optional Variant. The name of a column or row field in the PivotTable report.
Item7 Optional Variant. The name of an item in Field7.
Field8 Optional Variant. The name of a column or row field in the PivotTable report.
Item8 Optional Variant. The name of an item in Field8.
Field9 Optional Variant. The name of a column or row field in the PivotTable report.
Item9 Optional Variant. The name of an item in Field9.
Field10 Optional Variant. The name of a column or row field in the PivotTable report.
Item10 Optional Variant. The name of an item in Field10.
Field11 Optional Variant. The name of a column or row field in the PivotTable report.
Item11 Optional Variant. The name of an item in Field11.
Field12 Optional Variant. The name of a column or row field in the PivotTable report.
Item12 Optional Variant. The name of an item in Field12.
Field13 Optional Variant. The name of a column or row field in the PivotTable report.
Item13 Optional Variant. The name of an item in Field13.
Field14 Optional Variant. The name of a column or row field in the PivotTable report.
Item14 Optional Variant. The name of an item in Field14.
Field15 Optional Variant. The name of a column or row field in the PivotTable report.
Example
In this example, Microsoft Excel returns the quantity of chairs in the warehouse to the user. This example assumes a PivotTable report exists on the active worksheet. Also, this example assumes that, in the report, the title of the data field is "Quantity", a field titled "Warehouse" exists, and a data item titled "Chairs" exists in the Warehouse field.
Sub UseGetPivotData()
Dim rngTableItem As Range
' Get PivotData for the quantity of chairs in the warehouse.
Set rngTableItem = ActiveCell. _
PivotTable.GetPivotData("Quantity", "Warehouse", "Chairs")
MsgBox "The quantity of chairs in the warehouse is: " & rngTableItem.Value
End Sub