2 Replies Latest reply on Nov 12, 2013 8:57 PM by Artem Prytkov

    Calculate rank based on column values

    Artem Prytkov

      I'm trying to show a rank based on sales for shops without using sorting. It can be done manually with Rank function in Excel, where I can set cell and range to calculate ranking, but I can`t find anything similar in Tableau.

       

      I can successfully use Index() function to show rank, when I sort turnover by one column, but cannot calculate it for few columns.

       

      Excel file with example of required report and twbx file attached for example.

      Thanks in advance.