Pivot Table Sum a Range using GetPivotData

Question

I have a large pivot table and I want to identify the beginning of a sum array by using the GetPivotData formula  Then sum down a variable number of cells.

Any ideas of how can I do this?

Answer 1

No, although information, this didn't give me the funtionality I wanted. 

I found a workaround which enabled me to do what I needed, but not in the manner I would like to have done it.

Answer 2

Hi TryingSomthingNew,

Did you refer to Tom's reply?

Regards,

Tina

Answer 3

Getpivotdata pulls back specific elements of a pivot table basically using the name of those elements.  It isn't designed to do separate summarizations of the pivot table - the pivot table is used to do that and getpivot pulls that information back.

from help on getpivotdata:

Description

Returns data stored in a PivotTable report. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.

Note  You can quickly enter a simple GETPIVOTDATA formula by typing = (the equal sign) in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return.

Syntax

GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)

--

Regards,

Tom Ogilvy