3 Replies Latest reply on Aug 22, 2018 6:33 AM by Steffi B

    Indexing/Ranking Dimension Items in Tableau

    Sumeet Bedekar

      Hi Data Lovers,

       

      Column "A" is the sample data. and Column "B" is expected result.

       

      If you see closer, letter "B" is occured for 5 times and then we need to assign index as 5,

       

      Formula for Excel : - =IF(A1<>A2,COUNTIF($A$2:$A$18,A2),B1-1)

       

      Is there any way to get Column B in Tableau ?

       

      Regards,

      Sumeet