Last Modified Date: 10 Sep 2017
- Create a calculated field.
- Use an
IF/THENstatement in the formula.
- Place the field on the view.
CauseTableau Desktop will filter out values before aggregating the data.
Additional InformationWhen filtering using the filters shelf, Tableau Desktop will filter all of the marks associated with the dimension member at the lowest level of aggregation. Using the
IF/THENstatement method above will remove certain measure values from the view before the values are aggregated at the level of detail in the view.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials