2 Replies Latest reply: Oct 24, 2011 4:13 PM by Gualter Guizado RSS

    Top x Percent

      Hi guys having a bit of a strugle resolving a problem, lets say i have this table:

       

      Company
      Revenue
      A200
      B150
      C130
      D110
      E90
      F80
      G60
      H30
      I20
      J10

      Now the total is 880 and im after a table that will show me Companies based on 80% of the top Revenues, 80% is 704, so basically my table would show me from company A to company F, that would make 760 thus showing me all the Companies that make at least 80% of the Revenue.

       

      Many Thanks