Exercise: practical FIXED

This exercise will look at a problem that occurs when mixing a table calculation that calculates the percentage of the total with a dimension filter. We will consider the problem, a workaround used in previous versions of Tableau, and a solution using an LOD calculation. After covering these three options, a commentary section will discuss the germane points of each.

Exercise steps: practical FIXED – the problem

The following steps will guide you through the exercise:

1. Open the workbook associated with this chapter and navigate to the worksheet entitled The Problem.
2. Select the 2012_World_Pop dataset.
3. Create a calculated field named Percent of Total with the following code:

SUM([Population...