GetData Method
Applies To
PivotTable object.
Syntax
expression.GetData(Name)
expression Required. An expression that returns a PivotTable object.
Name Required String. Describes a single cell in the PivotTable, using syntax similar to the PivotSelect method or the PivotTable references in calculated item formulas.
Example
This example shows the sum of revenues for apples in January (Data field = Revenue, Product = Apples, Month = January).
Msgbox ActiveSheet.PivotTables(1) _
.GetData("'Sum of Revenue' Apples January")