GETPIVOTDATA problem


D

Don

Let's say I have a pivot table where the three row labels
in cells A5, A6, and A7 are Huey, Dewey and Louie. The
two column labels in cells B4 and C4 are Day Job and Night
Job. The amounts summed refer to wages.

If I enter GETPIVOTDATA(A3:D8,"Louie Night Job", the
result are the wages Louie earns at his night job. So
far, so good.

However, I get an #N/A if I should do the following: In
the underlying data I change the name from Louie to
Louis. I refresh the pivot table so that the row label
now reads Louis, not Louie. I also change the
GETPIVOTDATA function to GETPIVOTDATA(A3:D8,"Louis Night
Job").

This is driving me crazy. Any ideas? Thanks for your
help.
 
Ad

Advertisements

D

Debra Dalgleish

If a label is multiple words, it should be enclosed in single quotes,
e.g. "Louis 'Night Job'"
 

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

Top