4 Replies Latest reply on Nov 15, 2018 5:59 AM by mudassar.hussain.1

    Top 10 Sites by Rev else Others

    mudassar.hussain.1

      Hi Guys,
      I have been trying to create a Bar Chart in which i need to show Top-10 Sites by Revenue and all other Sites goes into 'Others' Category.

      Chart look like :

      In PostgreSQL, i have done this :
      Case when rank <=10 then @Site(FieldName) else 'Others' end as 'Other_site'

      But i do not know, how to calculate the rank in tableau.Please help me.
      Thanks,