1 2 Previous Next 15 Replies Latest reply on Jul 9, 2014 1:56 AM by mehak jaggia

    Top N products by Sale in Tableau

    mehak jaggia


      Hi All,

       

      I want to create the table in Tableau in which I need to get the TOP 5 Products name based on their sale amount.

      If you see in my attached workbook. I have the columns nm, amount. Now my requirement is to get the top 5 nm based on the amount( i.e the highest amount nm 1st rank, and subsequently 2nd , 3rd , 4th and 5th)

       

      I want to use thsi column top N by amount in the dashboard then so thats why I want to create a independend field for the same.

      pLease help me how can I achieve the same. I have created some dummy data from google as per my requirement. Please see the attached file and help.

       

       

       

      Regards,

      Mehak

        1 2 Previous Next