1 Reply Latest reply: Mar 19, 2018 12:34 PM by Sunny Talwar RSS

    Exclude selected company and calculate to ranked sales

    Arjun Madhusudan

      Hi,

       

      I have data as below

       

      Company    Sales

      A                  1000

      A                     400

      B                    500

      B                      20

      C                  2000

      D                    400

      D                      20

       

       

      I need to calculate     Sum of sales selected company  divided by   Sales of company with highest sale from the remaining list ( not selected)

       

       

      Regards,

      Arjun