Excel 97 - GETPIVOTDATA Help!!

jordi2k | 09:59 Thu 01st Feb 2007 | Technology

0 Answers

I am stumped!..

I have a list of data, pivoted by region to sum overdue and target debt. I am trying to use the "GETPIVOTDATA" function to pull this information into a table automatically however...

My "Region" field (Row section on Pivot) contains both numeric and alpha-numeric values.

The formula =GETPIVOTDATA($A$10,"Belfast Sum of Outside Credit") returns the Sum of Outside Credit for the Belfast Region, but change Belfast for the region code "107" and it returns an #N/A.

I have tried turning the region in the data to text, I have tried manually putting the ' quote infront to force text. I have even tried to rename these as "107 test" to make then non-numeric and it still won't work!!

Can you reference this using a numeric row?
Several website's provide examles where their data is numeric and suggest that it works fine!?!!

computer programme like index cards??

Vista on EBAY

Answers

Best Answer

Nobody has yet answered this question. Once some answers have been given, jordi2k will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

There are no answers available for this question.

Do you know the answer?