Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getpivot data dynamic reference
Hi all,
I am using the getpivotdata to retrieve data from a pivot table, the formula contains references to cells $C$4,$D$4 for different items of the fields of the pivot table, where the user can choose via a dropdown menu the values. =GETPIVOTDATA("Sum of Volume 1",'Summary 1'!$A$4,"Month",$C $4,"Country",$D$4) Would it be possible to do the same for the data field "Sum of Volume 1" and the pivot table name 'Summary 1'!$A$4 as I have different pivot tables. I tried the following formula for the pivot table name: =GETPIVOTDATA("Sum of Volume 1","'"&G4&"'"&"!$A$4","Month",$C $4,"Country",$D$4) where G4="Sum of Volume 1" but excel gives me #ref. any idea? thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getpivot data dynamic reference
Excel 2007 PivotTable
GetPivotData with drop-down lists. http://c0444202.cdn.cloudfiles.racks...02_02_10b.xlsx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getpivot data dynamic reference
Herbert Seidenberg wrote on 02/05/2010 12:59 ET :
Excel 2007 PivotTable GetPivotData with drop-down lists. http://c0444202.cdn.cloudfiles.racks...02_02_10b.xlsx thanks for this reply! You saved my life (figuratevely speaking)! I've been searching for this solution for a few hours until I found your solution |
#4
|
|||
|
|||
Quote:
Thnx =GETPIVOTDATA("[Measures].[COUNT]",'PIVOT SHEET'!$A$3,"[Country].[Zone Name]",$A$2) example http://goo.gl/mXJNJm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle for GetPivot Data in Office 2007 Excel | Excel Discussion (Misc queries) | |||
#ref! in calculations off of a getpivot data sum | Excel Worksheet Functions | |||
Getpivot date w/ relative reference | Excel Worksheet Functions | |||
GETPIVOT DATA HELP - PLEASE!!!! | Excel Worksheet Functions | |||
Reference / Copy Dynamic Data | Excel Discussion (Misc queries) |