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

    Exclude selected company and calculate to ranked sales

    Arjun Madhusudan



      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)