How to filter out the value when the difference is 0
Published: 03 Mar 2023 Last Modified Date: 06 Mar 2023
How to filter out the value when the difference is 0 before:
Tableau Desktop 2022.4.1
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.