Posted to microsoft.public.excel.worksheet.functions
|
|
Excel 2000 pivot HELP!!!!
You can create the string with cell references, e.g.:
GETPIVOTDATA($C$5,"'" & H11 & "' '" & H12 & "' '" &H13 & "'")
Matt wrote:
I have created a formula in Excel 2003 for getting Pivot Table Data that
doesn't work in 2000. The formula for 2000 seems to be wanting a text string,
but the variable that needs to be looked up everytime is changing...
Here is the formula in 2003:
=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA("Responders", 'Response Pivot
Table'!$C$6,"M Code",Report!A10,"Week",$AB$12))
So, based on the condition, I want the data for responders for a specific M
Code and Week value....those are always changing, so it has to be dynamic.
But, it seems that for 2000 the form is:
'=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA('Response Pivot Table'!C5,"Text
String"))
How do I get the text string if my value always change? I'm stuck and need
some help quick if possible!! I thank you in advance....
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
|