GETPIVOTDATA function

[Guest]

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.

 

[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")