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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
How to translate a getpivotdata formula into a cell reference 0
Getpivotdata - able to reference to another cell all parameters but not the datafield 6
pivot 0
Excel 2007 GetPivotData Function 2
Use cell_ref in place of an item in get pivot data function 2

Top