1 Reply Latest reply on Feb 26, 2017 11:22 AM by Jim Dehner

    Calculated Field for Rows

    Alex Marlow

      Hi everyone,


      I am working on a project and have the correct data. I just need to find the winners based by percentage which is already sorted.



      I would like to be able to label each person as first and second.


      Thanks in advance for your help!

        • 1. Re: Calculated Field for Rows
          Jim Dehner

          Hi Alex   


          Looking at the way you have set up your sheet you should be able to use a table calculation for Rank >> RANK(SUM([General %]),'desc')


          You may need to co to the table calculation editor Specific Dimensions - you want to rank the Candidates Restarting every District Ascending