KNOWLEDGE BASE

Adding a Filter to Grand Total


Published: 25 Aug 2017
Last Modified Date: 25 Aug 2017

Question

How to filter a view based on the value of the Grand Total.

Environment

Tableau Desktop

Answer

Aggregate the measure up to the level of detail of the grand total using a calculation similar to the following: 

IF { EXCLUDE [Ship Date]:SUM([Profit]) }<40000 THEN 'yes'
else 'no'
END


Put this calculation on the filters shelf as an 'attribute' and filter out all but 'yes'.

In this specific example, whenever the grand total is less than 40000 only this row will be displayed.

Additional Information

The above steps can be reviewed in the attached workbook filtergrandtotal.twbx.
Did this article resolve the issue?