Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Reference
My worksheet has a refence to a cell in a pivot chart. Instead of the
formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#2
|
|||
|
|||
Type =, then click on the relevant cell in the pivot table
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shivpora" wrote in message ... My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#3
|
|||
|
|||
If you don't want to show the pivot formula you'll need to manually type the
address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#4
|
|||
|
|||
I did not have this issue on my old system which had the same excel version
i.e 2003. So I do believe there is some setting where this can be changed. ANyone else knows the answer to this??? "Matt Lunn" wrote: If you don't want to show the pivot formula you'll need to manually type the address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#5
|
|||
|
|||
Please explain the 'issue' in more detail. What do you want to do?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shivpora" wrote in message ... I did not have this issue on my old system which had the same excel version i.e 2003. So I do believe there is some setting where this can be changed. ANyone else knows the answer to this??? "Matt Lunn" wrote: If you don't want to show the pivot formula you'll need to manually type the address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#6
|
|||
|
|||
I am looking to have the cell formula referencing a cell in a pivot chart to
be a simple cell refernce and not the underlying " get Pivot data formula instead" e.g. if the pivot chart range is A1: K25 and my formula in cell m1 needs to reference the value in the pivot table cell J20 I should simply be able to go to cell M1, type an +sign and click on cell J20 on the pivot chart to get cell M1 formula as =J20. However, I am getting =GETPIVOTDATA.........etc instead. How do I turn this off? "Bernard Liengme" wrote: Please explain the 'issue' in more detail. What do you want to do? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shivpora" wrote in message ... I did not have this issue on my old system which had the same excel version i.e 2003. So I do believe there is some setting where this can be changed. ANyone else knows the answer to this??? "Matt Lunn" wrote: If you don't want to show the pivot formula you'll need to manually type the address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
#7
|
|||
|
|||
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html shivpora wrote: I am looking to have the cell formula referencing a cell in a pivot chart to be a simple cell refernce and not the underlying " get Pivot data formula instead" e.g. if the pivot chart range is A1: K25 and my formula in cell m1 needs to reference the value in the pivot table cell J20 I should simply be able to go to cell M1, type an +sign and click on cell J20 on the pivot chart to get cell M1 formula as =J20. However, I am getting =GETPIVOTDATA.........etc instead. How do I turn this off? "Bernard Liengme" wrote: Please explain the 'issue' in more detail. What do you want to do? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shivpora" wrote in message ... I did not have this issue on my old system which had the same excel version i.e 2003. So I do believe there is some setting where this can be changed. ANyone else knows the answer to this??? "Matt Lunn" wrote: If you don't want to show the pivot formula you'll need to manually type the address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#8
|
|||
|
|||
Thanks Debra... that worked.
"Debra Dalgleish" wrote: There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html shivpora wrote: I am looking to have the cell formula referencing a cell in a pivot chart to be a simple cell refernce and not the underlying " get Pivot data formula instead" e.g. if the pivot chart range is A1: K25 and my formula in cell m1 needs to reference the value in the pivot table cell J20 I should simply be able to go to cell M1, type an +sign and click on cell J20 on the pivot chart to get cell M1 formula as =J20. However, I am getting =GETPIVOTDATA.........etc instead. How do I turn this off? "Bernard Liengme" wrote: Please explain the 'issue' in more detail. What do you want to do? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shivpora" wrote in message ... I did not have this issue on my old system which had the same excel version i.e 2003. So I do believe there is some setting where this can be changed. ANyone else knows the answer to this??? "Matt Lunn" wrote: If you don't want to show the pivot formula you'll need to manually type the address of the cell you want to reference instead of clicking it. If you want to reference the value at J50 then type "=J50" Thanks, Matt "shivpora" wrote: My worksheet has a refence to a cell in a pivot chart. Instead of the formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |