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.

GETPIVOTDATA function
 

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