KNOWLEDGE BASE

How To Filter The Results Of Table Calculations


Published: 24 Jan 2021
Last Modified Date: 27 Jan 2021

Question

How to filter the Category without changing the rank results of Sub-category?

Environment

  • Tableau Desktop

Answer

  1. Create a calculation field rank to calculate the rank results of the sum of sales.
    rank(sum([Sales]))
  2. Drag Sun-Category to Rows, rank to Text in Marks card.
  3. Create a table calculation field Filter Category to filter the rank results
    lookup(attr([Category]),0)
  4. Drag Filter Category to the Filters card and select the category to be show
Did this article resolve the issue?