O'Reilly logo

Tableau 10.0 Best Practices by Jenny Zhang

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Custom Total

Custom Grand Total

I will use the Superstore data set for this example.

For example, you want to get the sum of the average sales for each customer segment in the Grand Total row. But what you are getting now is the overall average of the data source, which is as follows:

Custom Grand Total

How is Tableau calculating the Grand Total? It is performing the same calculation for the measure as it does for the Dimension in the view, but at a higher level. In this case, the entire data source is considered instead of each customer segment. Tableau uses all the dimensions on the columns to calculate column Grand Total. Same goes for row Grand Total.

In the example, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required