GetPivotData Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb Reinhardt - 08 May 2008 16:09 GMT

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

Reply to this Message

Debra Dalgleish - 09 May 2008 00:34 GMT

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.

> I have the following GetPivotData formula
>
[quoted text clipped - 13 lines]
> Thanks,
> Barb Reinhardt

Signature

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

Reply to this Message