Question
How to get a fixed rank with a filter in a cross table. which means if the filter narrows the data showing in the table, the rank should be as same as the rank with the whole table.
Last Modified Date: 01 Feb 2021
Environment
- Tableau Desktop
Answer
Create a calculation field to replace the [Region] field in [Filter] shelf.The calculation is as below:
LOOKUP(ATTR([Region]),0)
Please see the attached workbook.
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