2 Replies Latest reply on May 13, 2017 5:00 PM by Christoph Wolf

    Combined Table Rank - how?

    Christoph Wolf

      Hello!

       

      https://public.tableau.com/static/images/Tr/Trainer-TabelleFuball-Bundesliga-eigeneBerechnung/Blatt6/1.png

      I'd like to rank according to three criteria to get a properly ranked soccer table (just like here):

       

      1. points (Punkte) - descending

       

      if points are equal look at

       

      2. +/- - descending

       

      if points and +/- are equal look at

       

      3. goals (Tore) - descending

       

      I tried this formula (STR(RANK(SUM([Punkte_gesamt])))+ "-" +STR(RANK(SUM([Tordifferenz]))))+ "-" +STR(RANK(SUM([Tore_gesamt]))) but i did't work since "Tordifferenz" and "Tore_gesamt" were rank the wrong way (ascending)

       

      Any ideas and help appreciated!

       

      Thanx

      Christoph