GETPIVOTDATA function

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.

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

bbddvv wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html