GETPIVOTDATA formula linked to Combo Box

Hi all,

How can I write below GETPIVOTDATA formula to include all items of my field "Comp Status" if "ALL" is selected in my Combo Box? I have a named range called "Selection" that gets the value from the Combo Box, but if I select "All", that obviously won't work even if I try that with the "*" instead of "All". Is that solvable within the formula or do I need a nested IF to work around it?

e.g.

Please Login or Register  to view this content.

Sorry if I wasn't clear enough.

what I meant is, I have a Combo Box (see below) where I select the Comp Status I want to look at. So my GETPIVOTDATA formula (field 5) refers to the Combo Box's cell link.

Capture.PNG

So if "Non Comp" is selected in my Combo Box, the formula would 'look' as follows:

Please Login or Register  to view this content.

But obviously, if I want to consider ALL items of that field, I was hoping the formula could look like that:

Please Login or Register  to view this content.

where "*" means it 'neglects' that field or sums ALL items it finds for that field in the pivot. The items "NON COMP" or "*" are obviously coming from the Combo Box cell link, above is just for illustration purposes...