PivotTable.GetData Method

Syntax

expression.GetData(Name)

expression A variable that represents a PivotTable object.

Parameters

Name	Required/Optional	Data Type	Description
Name	Required	String	Describes a single cell in the PivotTable report, using syntax similar to the PivotSelect method or the PivotTable report references in calculated item formulas.

Return Value
Double

Example

This example shows the sum of revenues for apples in January (Data field = Revenue, Product = Apples, Month = January).

Visual Basic for Applications
`Msgbox ActiveSheet.PivotTables(1) _ .GetData("'Sum of Revenue' Apples January")`

get data Get data from pivottable? Get Data Method getdata GetData Method Retrieve the value from a specific pivottable cell?

Returns the value for the a data filed in a PivotTable.