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.