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

You've removed a field name and item from the formula, but unless the
pivot table structure also changed, there won't be a summary cell in the
pivot table that matches the fields and items left in the formula.

If you take Sum.OI Category out of the formula, it would also have to be
removed from the pivot table layout, or moved below the fields remaining
in the formula.

Barb Reinhardt wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html