Learning Tableau 2019 - Third Edition

EXCLUDE

Exclude level of detail expressions aggregate at the level of detail determined by the dimensions in the view, excluding any listed in the code. For example, the following code calculates the average price at the level of detail defined in the view, but does not include the Apartment dimension as part of the level of detail, even if Apartment is in the view:

{EXCLUDE [Apartment] : AVG([Price])}