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
