2 Replies Latest reply on Mar 19, 2014 12:11 PM by Bill Palombi

    Sum all values outside of top 10 Rank

    Bill Connelly

      Hi,

       

      I am trying to use the following formula,  if rank([Total UK employees])  > 10 then "All Others" else attr({Contractor Name])  .  I want the names of contractors with the top ten total number of UK emplyees.  All others I want captured under the label "All Others".  However when I put it on the Rows shelf I only get an *.  

       

      Please Help,

       

      Thanks,

      Bill