6 Replies Latest reply on Jun 30, 2016 6:48 AM by Luciano Vasconcelos

    grouping top customers to perform analysis

    Kumar.0001

      Hi, I think this might be very easy for most of you but I am not able to get it and need help. I want to group the top 3 customers and study

      1. Their percentage contribution each year in the total sales of that year.

      2. Their sales' movement w.r.t the average of the top 3 customers.

      3. Their sales' movement w.r.t the average of all the customers.

       

      Attached is my twbx file. For the first question I just want a label added to my bars to indicate the group's share in that year's sales.

      Any help would be appreciated. Thanks.