| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can you use a variable or cell reference in a getpivotdata formul.
for example;
GETPIVOTDATA($B$7,"may 2004 grand total") can "may 2004" be a cell reference |
|
#2
|
|||
|
|||
|
You can do that, it would read like so: GETPIVOTDATA($B$7, $A$1 & " Grand Total") -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=276387 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
| cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions | |||
Linear Mode
