GETPIVOTDATA function

B

bbddvv

Hi, I am trying to pull data from a PivotTable using the GETPIVOTDATA
worksheet function. However, i dont know what to use for the "Data_Field"
item

=GETPIVOTDATA( ???????? ,$A$4,"Data","Number of Voters","Company","Brooks &
Co")

Help! Thanks.
 
D

Debra Dalgleish

It looks like you want the number of voters for a specific company, so
this may work:

=GETPIVOTDATA("Number of Voters",$A$4,"Company","Brooks & Co")
 
Top