Exclude based on certain conditions

[n1ef5ng1]

Hi I have this particular code based on chart 1

Sum({<

CO_Operator_Group_Code={'MM'},Consortium = {$(var_consortium_1)},Service_Type_Indicator={$(var_2)}

>} Sales))

Based on this eqn, it tell us that MM (Container Operator : CO) has the number of sales based on certain consortium and service type indicator. Note that consortium and service type are variables.Each of these variables contains 4 fields out of 30 in total.

For chart 2 , i will like to have the total Sales - chart 1 code to give chart 2. Is there any other code that I can use to get this Sales - Chart 1 = chart 2?

I would like to avoid using this :

sum({CO_Operator_Group_Code = {'MM'}>}Sales

-

Sum({<

CO_Operator_Group_Code={'MM'},Consortium = {$(var_consortium_1)},Service_Type_Indicator={$(var_2)}

>} Sales))

Consortium and service type indicator work like an or function. take in the sales amount so long if the sales does not contains consortium or service, type

[n1ef5ng1]

Anybody have any thoughts