GetData Method 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")