2 Replies Latest reply on Oct 13, 2016 11:27 AM by Johan De Groot

    Row-number after double sort/rank on measure

    Johan De Groot

      I have a table with a dimension and two measures. The table is sorted on both measures by creating 'ranked' table calculations.

      This works well - but now I want to have a rank in front of the rows. An index() doesn't work since the ranking mixes the rows - anyone any idea on how to put a 'row number' on the visualisation while the ranking/sorting is still in place?

      Attached a small example of my workbook