3 Replies Latest reply on Aug 24, 2018 11:13 AM by Simon Runc

    Automatically Sort Multiple Rates in Descending Order with Filters

    Jenna Glickman

      Hello all,

       

      I have been wracking my brain trying to get Tableau to automatically sort multiple rates in descending order with a filter!

       

      Let's say I've asked hundreds of respondents from different states about some foods, code each food as a dichotmous variable (1=I like this food, 0 = dislike), and then use Tableau to calculate the rates (SUM([FOOD]))/(SUM([Number of Records])). However, I want to be able to look at the rates by location, so I create a filter. I also want to display the rates in descending order. The "sort Measure Names descending by Measure Values" icon in red at the top works perfectly.

      Example1.png

      Example2.png

      However, when I change the location to Oregon, the rates do not automatically resort in descending order, and I have to click the button again. Is there a way to set this up so Tableau knows to sort the values automcatically when there are multiple rates and a filter? The packaged workbook is attached. Thank you!