How can I get the GETPIVOTDATA function to reference another cell for the inputs without manually writing text in between parenthesis?
How can I get the GETPIVOTDATA function to reference another cell for the inputs without manually writing text in between parenthesis?
You can just reference the cells directly:
GETPIVOTDATA(data_field,pivot_table,field,item,...)
The data_field can be a cell reference but you have to concatenate double quotes for it to work
The pivot_table is generally an absolute reference to the top left most cell in the pivot (This is what I use)
The field and item can be directly from your worksheet
Something like:
GETPIVOTDATA(A1 & "",$E$1,B1,B2) where
A1 = "GDP"
$E$1 is the location of the Pivot
B1 contains the word "Country"
B2 contains "USA"
If your pivot has GDP by country and USA is one of them then the formula will return the value.
If the post was helpful please click the black star on the bottom left to add some reputation and mark your thread as SOLVED.
A day with nothing new achieved or learned, albeit however small, is a day lost forever?
Constant Never Ending Improvement
Thank you, this works, for some reason it wasnt working before.
No worries, glad you got it working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks