Last Modified Date: 15 Feb 2017
Option 1: Add the Filter Field to Context
- On the Filters shelf, right-click the field being used to filter the view, and then select Add to Context. For more information, see Creating Context Filters in Tableau Help.
Option 2: Use Index() and a Table Calculation
- Follow the instructions in the Finding the Top N Within a Category article to use an index value and a table calculation.
Option 3: Filter Using a Calculated Field
- Right-click a blank area in the Data window and select Create Parameter.
- Name the parameter Filter Parameter.
- Add data from the field being used to filter the view to the parameter.
- Select Analysis > Create Calculated Field.
- Name the field and add the following calculation to the Formula field:
IF ([<field>] = [Filter Parameter]) THEN [<measure>] ELSE 0 END
- Replace the measure in the view with the new calculated field.
CauseThe Top N sort is calculated before looking at the field on the Filters shelf.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials