Last Modified Date: 26 Jun 2023
Environment
Tableau DesktopAnswer
Option 1: Create a Set
- Right-click on the desired dimension and select Create Set.
- Name the set.
- Exclude the desired members.
- Click OK.
- Place the newly created set on the Filters shelf.
- Place the set on the Rows or Columns shelf, as desired.
Option 2: Create a Calculated Field
- Select Analysis > Create Calculated Field....
- Name the field as desired.
- Place the following formula into the formula window:
IIF([measure]=0, 'Exclude', 'Include')
- Click OK.
- Place newly created calculated field on the Filters shelf.
- Select desired filter option, Exclude or Include.
Additional Information
Create SetsThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials