| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing within a GetPivotData function
I am having issues refrencing cells within a the function.
If J1 holds the text "April", I am using: =GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project Text RMT]","[Project Text RMT].[All Project Text RMT].[Frontier]",INDIRECT("[Time]","[Time].[All Years].[2007].[Q2].["&J1&"]")) which is returning #VALUE! however, when I use the same formula ending with ]","[Time].[All Years].[2007].[Q2].[April]" the call works correctly. Thanks for any help with this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing within a GetPivotData function
Did you try:
=GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project Text RMT]","[Project Text RMT].[All Project Text RMT].[Frontier]",]","[Time].[All Years].[2007].[Q2].[" & J1 & "]") HTH, Bernie MS Excel MVP "Michael" wrote in message ... I am having issues refrencing cells within a the function. If J1 holds the text "April", I am using: =GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project Text RMT]","[Project Text RMT].[All Project Text RMT].[Frontier]",INDIRECT("[Time]","[Time].[All Years].[2007].[Q2].["&J1&"]")) which is returning #VALUE! however, when I use the same formula ending with ]","[Time].[All Years].[2007].[Q2].[April]" the call works correctly. Thanks for any help with this. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing within a GetPivotData function
Thanks, I though I would have to use INDIRECT in some way.
"Bernie Deitrick" wrote: Did you try: =GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project Text RMT]","[Project Text RMT].[All Project Text RMT].[Frontier]",]","[Time].[All Years].[2007].[Q2].[" & J1 & "]") HTH, Bernie MS Excel MVP "Michael" wrote in message ... I am having issues refrencing cells within a the function. If J1 holds the text "April", I am using: =GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project Text RMT]","[Project Text RMT].[All Project Text RMT].[Frontier]",INDIRECT("[Time]","[Time].[All Years].[2007].[Q2].["&J1&"]")) which is returning #VALUE! however, when I use the same formula ending with ]","[Time].[All Years].[2007].[Q2].[April]" the call works correctly. Thanks for any help with this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GETPIVOTDATA function | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA function | Excel Worksheet Functions | |||
| using getpivotdata function | Excel Worksheet Functions | |||
| GETPIVOTDATA function | Excel Worksheet Functions | |||
| Can you get around the GETPIVOTDATA command when referencing a pi. | Excel Worksheet Functions | |||
Linear Mode
