6 Replies Latest reply on Jan 5, 2017 2:28 PM by Chris C

    Ranking Percent of Total (Across) Using Index

    James Malone

      Hello, I have some information about different areas of the UK with different amounts of Failures/Successes; I would like to be able to rank/index the Success Percent instead of the Count of successes however so i can then have the "3 Most Successful Areas" in a chart.

       

      My problem is when i add the table calculation, the sort button disappears and if i follow Finding the Top N Within a Category | Tableau Software then it breaks down in the index calculated field step as it counts the whole table as the index 1 and doesn't rank each row accordingly as seen in the packaged workbook.

       

      Any help would be great, thanks.

       

      James