Learning Tableau 2019 - Third Edition

Late filtering

Let's say you've built a view that allows you to see the percent of total sales for each department. You have already used a Quick Table Calculation on the Sales field to give you the percent of the total. You've also used Department as a filter. But this presents a problem.

Since Table Calculations are performed after the aggregate data is returned to the cache, the filter on department has already been evaluated at the data source and the aggregate rows don't include any departments excluded by the filter. Thus, the percent of the total will always add up to 100%; that is, it is the percentage of the filtered total, as shown in the following screenshot:

What if you wanted to see the percentage of the total sales for all ...