Last Modified Date: 05 Jan 2023
Environment
- Tableau Desktop
Answer
The attached workbook created from Sample - Superstore demonstrates the following steps.- Right-click State > Create > Parameter.
- In the create parameter window, name the parameter as State 1 and add All to the list of values, then click OK.
- Right-click the State 1 parameter > Duplicate and rename the duplicated parameter as State 2.
- Click Analysis > Crate Calculated Field to create the AND Logic Filter calculated field with the following formula.
{FIXED [Product Name]: MAX([State]=[State 1]) OR [State 1]="All"} AND {FIXED [Product Name]: MAX([State]=[State 2]) OR [State 2]="All"}
- Right-click the State 1 parameter > Show Parameter.
- Right-click the State 2 parameter > Show Parameter.
- Place Products and State to rows and Sales to text.
- Place AND Logic Filter to filters and select True.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials