Getpivotdata problem
 

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)

Getpivotdata problem
 

Include single quotes around that part of the formula:

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


Al wrote:
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)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Getpivotdata problem
 

Fantastic - works brilliantly!!

Cheers for your help Debra, really appreciated.

Al.

"Debra Dalgleish" wrote:

Include single quotes around that part of the formula:

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


Al wrote:
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)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com