Quote:
Originally Posted by goback
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
|
Hi there, I have a similar problem with Getpivot and reference, but nothing works so far for my excel. Would be so kind and have a look pls?
Thnx
=GETPIVOTDATA("[Measures].[COUNT]",'PIVOT SHEET'!$A$3,"[Country].[Zone Name]",$A$2)
example
http://goo.gl/mXJNJm