Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA problem | Excel Discussion (Misc queries) | |||
Problem with getpivotdata function | Excel Discussion (Misc queries) | |||
getpivotdata refresh problem | Excel Worksheet Functions | |||
GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions | |||
GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions |