Getpivotdata problem


A

Al

Hoping you can help.

I have a Getpivotdata function as per below that successfully returns the
relevant data for all of my records with the exception of one. I believe
this is down to the data itself but as this is based on query results from a
core system I can't change this data.

The Data specifically in question is in cell B43 within my Reports sheet and
contains "US & Canada". I believe that it's the & that is causing the
problem, is there anyway I can adapt my function to cater for this being
valid?

Thanks, Al.

C43 (Reports Sheet):
=GETPIVOTDATA('Remedy Reports'!B$182,$C$32 &" " & "Sum of " &Report!$C$5 &"
" &Report!$B43)
 
Ad

Advertisements

D

Debra Dalgleish

Include single quotes around that part of the formula:

=GETPIVOTDATA('Remedy Reports'!B$182,$C$32 &" " &
"Sum of " &Report!$C$5 &" '" &Report!$B43 & "'")
 
Ad

Advertisements

A

Al

Fantastic - works brilliantly!!

Cheers for your help Debra, really appreciated.

Al.
 

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 problem 4
Problem with getpivotdata function 1
=GETPIVOTDATA 0
GETPIVOTDATA 0
GETPIVOTDATA 2
GETPIVOTDATA 3
getpivotdata 1
GetPivotData 1

Top