3 Replies Latest reply on Dec 9, 2016 8:09 PM by Shinichiro Murakami

    Dynamic Sort in Hierarchy

    Saket Dabi

      Hello

       

      I am trying to implement dynamic sort using parameter in tableau hierarchy that runs like this Brand-Shop-Dept. User can select the measure they want to sort the table using the parameter.

      It works on the highest level i.e Brand but doesnt seems to work when user drill down into sub categories. I need the table to be sorted for every level that is drilled into.

       

      I cant use the rank and hide it to attain nested sort as drill ability is a primary feature.

       

      For the below table if the user select Sale (calculated field) as a sort column , it works well at Brand level but doesnt at Dept and so as for Profit (calculated field)

       

      any thoughts ?

       

      Brand
      Sub Category (Department)
      SaleProfit
      NikeApparel100200
      footwear5010