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

           

          Jim