Getpivotdata

  • Thread starter Thread starter David Morris Evans
  • Start date Start date
D

David Morris Evans

I want to use GETPIVOTDATA to pick from a table in which the first column is
a state designator and is not repeated in every record - is this feasible?
I will use the state designator and a code (from the second column of the
Pivot table) to give me the correct premium rate to be applied using MATCH
and INDEX

But I'm striking out on getting the state in any row other than the one it
shows up in ...

My brainbox is fired on this
.....
 
The row labels only appear once, and there's no setting you can change
to make them appear in every row.

However, the GetPivotData function will return the specified value, even
when the labels are not in the worksheet row that contains the value.

Did you try a formula? What problems did you encounter?
 

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

Rows disappear in pivot table 1
GETPIVOTDATA function on pivot filter 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
GetPivotData Multiple Fields 6
GETPIVOTDATA #REF! error XL2003/2010 1
Getpivot data dynamic reference 1
Pivot Table Calculated field error 1

Back
Top