View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default GetPivotData Question

I have the following GetPivotData formula

=GETPIVOTDATA("Sum of ProjEstV.Value",'Validated Value Pivot'!$A$6,"Status
Month","2008-04","Sum.OI Category","Other","OI Goal
Category","OPS","CloseOIYr","","Status","Assigned" )

Which works fine. I just don't want to use the part
"Sum.OI Category","Other"

So I get

=GETPIVOTDATA("Sum of ProjEstV.Value",'Validated Value Pivot'!$A$6,"Status
Month","2008-04","OI Goal Category","OPS","CloseOIYr","","Status","Assigned" )

which gives me a REF error. WHY?
Thanks,
Barb Reinhardt