GETPIVOTDATA with an Array

S

Steve

Is there a way to use an array within the GETPIVOTDATA function? If one of
the fields in a pivot table is "City" and I want to get results for multiple
cities I currently use as many GETPIVOTDATA functions in one formula as I
can. If an array could be used I would only need on GETPIVOTDATA formula,
that would be great. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
2007 Excel - GETPIVOTDATA 2
pivot 0
GETPIVOTDATA from OLAP cube - grouped field 0
ISERROR on GETPIVOTDATA 1
Pivot Table GETPIVOTDATA 2
sum of getpivotdata() 0

Top