If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|