In Part 1 and Part 2 of this series, I described how Tableau computes Grand Totals and several options for generating your own Grand Totals. In this post, you’ll learn the most flexible method for customizing Grand Totals, via custom SQL to duplicate the data.
In November 2013 Tableau 8.1 also added a new two pass totals
feature that may remove the need for customizing grand totals for your use cases, more details are in Tableau 8.1 Two Pass Totals
. In December 2015 Tableau 9.3 added total control
for placing totals to the left and/or on top of the view.