Dynamic Getpivotdata in Excel XP

[valglad]

Folks


I urgently need help with this function.


I'm trying to make this function dynamic, i.e.


depending on some condition, make some members disappear or otherwise.


=getpivotdata("Loads",'Pivot Plan'!$a$3,"SHIPTO",A1,"MILL",B1 &
IF(D1="ALL","",","&"PRODUCT LINE")&IF(D1="ALL","",","&"LINE1"))


If cell D1 has value "ALL" then both "Product Line" and its value
("LINE1") are not used, if otherwise they should be used.


I've wasted hours playing with syntax, such as putting commas into
separate "if" statements, nothing works.


Appreciate any help.


Thanks

 

[Debra Dalgleish]

Did you try the suggestion that I posted yesterday?


http://groups.google.ca/groups?&[email protected]