3 Replies Latest reply on May 17, 2018 7:25 AM by arvindgarg

    How to create a parameter that allows me to sort the measure - sales - descending based on which car I select?

    Ava Kingsley

      Hi Tableau Community,

       

      I have three different car models - A, B, C. For each model I have the sales numbers by cities that they are sold in. I have "car models" as a dimension in columns as well as the "cities" in columns.

      The top cities by sales differ for each of the three cars.

       

      1. I would like to create a parameter that allows me to say I want to sort cities in a descending order (by sales) for Model A... Meaning I want to be able to choose model A, B, or C and then depending on which one I choose it sorts the cities in descending order by top cities for the selected model. If I choose Model A, then the cities shown for Model B and C are the same cities as the top ones for model A but obviously not in descending order (which is fine).

       

      2. I then want to be able to say - only show me the top X number of cities by sales for the model selected. So the top X cities for model A are the only cities shown for each model.

       

      Keep in mind, the three models are in the view the whole time.

       

      Thanks for your help,

       

      Ava