Last Modified Date: 15 Aug 2023
Environment
- Tableau Desktop
Answer
- Create a calculated field below
- Order_LOD: { FIXED [Region]:COUNT([Orders])}
- Drag the [Region] to the Columns shelf and then [Order(Count)] as well as the created [Order_LOD] to the Rows shelf.
- Now use category in filter and this will be applied to the [Order(Count)] not [Order_LOD]. It is because Fixed level of detail expressions compute values without reference to the dimension in the view.
Additional Information
Tableau's Order of OperationsThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials