9 Replies Latest reply on Aug 2, 2018 2:49 AM by Paulo Dantas

    Top 5 Cities in top 5 States

    Ryan Hawkins

      Hi guys,

       

      Wondering if you could help.

       

      Using the Sample - Superstore data from Tableau. How would i create a table showing the top 5 cities in the top 5 states based on sales.

       

      For example, below are the top 5 states in terms of sales. Now i would like the top 5 cities in those states (based on sales)

        

      California$457,688
      New York$310,876
      Texas$170,188
      Washington$138,641
      Pennsylvania$116,512

       

      Thanks!