Question
How to filter out the value when the difference is 0
before:
after:
Last Modified Date: 06 Mar 2023
Environment
- Tableau Desktop 2022.4.1
- Excel
Answer
1. Create a calculated field:Name: sales_difference
Value: ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)
2. Convert to discrete.
3. Drag it to the filter card, and exclude 0 and null.
See attached sample 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