Calculation Logic in bar chart

Ask a Question

Guys,

I have this bar chart below,

These 3 customers in this chart can have common fields mutually.

Based on this chart, I need to create another bar chart and in that chart, customer which is having highest count needs to come first.

(i.e Maersk needs to come first as per the above chart)

From the other 2 customers, second highest customer, Cargosmart has all the 4 fields common to Maersk. So, it should not be displayed.

and Addivant has 1 field out of 3 fields which is not common to Maersk.

Finally I need 5 for Maersk and 1 for Addivant. Comparison should always be based on the customer which is having highest count.

Please help me out guys since it is really very complicated for me.

Thanks,

Siva.

0 Replies