Displaying or adding Totals and subtotals in Tableau is the most natural thing, and it’s just a matter of checkmarks. In this article, we will show how to add totals in Tableau. And this includes adding Row Totals, Column Totals, Grand Totals, and Subtotals with a live example.
Steps to add Total in Tableau
In this example, we are going to add totals to the below-shown report. If you observe the below screenshot, it was just a standard table report.
To add Total in Tableau, go to Analysis Menu and select Totals and checkmark the required option. For instance, to display Rows total, we have to choose show row Grand Totals Option
Once you select the Show Row Grand Totals Option, an extra Grand Total column will add with all the row totals in Tableau report
To display the Column totals, go to Analysis Menu and select Totals. Next, checkmark the Show Column Grand Totals Option
Once you select Show Column Grand Totals Option, an extra Grand Total row will add with all the column totals. If you observe the below screenshot, we rounded 29,358,677 because it is the Super Grand Total of all products.
Now, let us see how to add subtotals in the tableau or display totals of nested regions. To explain this, we removed Country names from the column card and added them to rows card
Display or Add Subtotals in Tableau
To display or add Subtotals in Tableau, go to Analysis Menu. Select Totals, and checkmark the Add All Subtotals Option
Once you select Add All Subtotals Option, an extra row with Total will be added in the nested region to display the column totals. It is the subtotal in Tableau report
Remove Totals and Subtotals in Tableau
To remove Row Grand Totals and Column Grand Totals in Tableau, go to Analysis Menu and select Totals and uncheck the corresponding option. To remove Subtotals in Tableau, we have to select Remove All Subtotals Option