Summing Mulitple values from variant pivots

[analysis_paralysis]

Hello,
I am trying to add data from 3 different pivot tables for a certain value set, generally my equation is working but I am running into a problem with one of the categories as it is null in one of the three sets I am addding from - causing the entire thing to kick back blank.
Here is my equation - I need to modify so that it will sum the value of category "POS" and category "APOS" if category "Complex" is blank as well as the otehr variation possibilities (meaning: sum POS & Complex if APOS is blank, Sum APOS & Complex if POS is blank, Sum all 3 if none are blank).
Help would be great, I am so stuck!
A_P
=IF(ISERROR(GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","POS","New Segment",B18)+GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","Complex","New Segment",B18)+GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","APOS","New Segment",B18)),"",GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","POS","New Segment",B18)+GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","Complex","New Segment",B18)+GETPIVOTDATA("Add'l by EOQ",'Financial Pivot'!$A$1,"Probability_of_closure","60%","Category","APOS","New Segment",B18))

 

[PATSYS]

I strongly suggest that you turn off the GETPIVOTDATA so you can treat pivot tabe data just like any other sheet ranges.

 

[analysis_paralysis]

Generally speaking I would agree, my client is dead set on keeping the getpivotdata (his file) but I do appreciate your input.
That being said, I solved the problem already - my post was a bit premature.
Thanks,
A_P