Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Anybody have any thoughts