Excel.PivotTable.GetData.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.GetData method (Excel)	vbaxl10.chm235110	vbaxl10.chm235110	Excel.PivotTable.GetData	c3b88918-c515-a976-5f2e-107b981ac76f	05/08/2019	medium

PivotTable.GetData method (Excel)

Returns the value for the data filed in a PivotTable.

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).

Msgbox ActiveSheet.PivotTables(1) _ 
 .GetData("'Sum of Revenue' Apples January")

[!includeSupport and feedback]