1 Reply Latest reply on Apr 6, 2018 3:16 PM by Eric Hammond

    Tableau FIXED index or rank

    Colin Thomas

      Hoping the Tableau community can answer the below question.

       

      Trying to filter and have RAM's rank remain 3 rather than change to rank 1.

       

      Thanks in advance,

      Colin

      Tablea FIXED index or rank.PNG

        • 1. Re: Tableau FIXED index or rank
          Eric Hammond

          Hi Colin,

           

          Filter on a field that contains a table calculation; this forces index() to be evaluated before the filter is applied, so the rank is preserved.

          • [Brand Filter] = LOOKUP(MAX([Brand],0))
          • Drag [Brand Filter] to the Filters shelf
          • Right-click on the pill in the filters shelf and choose Show Filter
          1 of 1 people found this helpful