Add Totals in Tableau

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 subtotals and totals in Tableau. And this includes adding Row Totals, Column Totals, Grand Totals, and Subtotals with a live example.

For this Tableau Add Totals demo, we are going to use the data source we created in our previous article. So, Please visit Data Labels in Reports article to understand the Tableau Data Source.

Steps to add Total in Tableau

In this Tableau example, we will add totals and subtotals to the report below. If you observe the below screenshot, it was just a standard table report.

Table Report 1

To add Total, go to Analysis Menu, select Totals, and checkmark the required option.

For instance, we have to choose the show row Grand Totals Option to display the Rows total.

Show Row Grand Totals in Tableau 2

Once you select the Show Row Grand Totals Option, an extra Grand Total column will add to all the row totals in the Tableau report.

Add Totals 3

To display the Column totals, go to Analysis Menu and select Totals. Next, checkmark the Show Column Grand Totals Option.

Show Column Grand Totals in Tableau 4

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.

Display Grand Totals of Rows and Columns in Tableau 5

Now, let us see how to add subtotals in Tableau or display totals of nested regions. To explain this, we removed Country names from the column card and added them to the rows card.

Add Totals and subtotals in Tableau 6

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

Add to Table 7

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 the Tableau report.

Show in Table report 8

Remove Totals and Subtotals

To remove Row Grand Totals and Column Grand Totals in Tableau, go to Analysis Menu, select Totals, and uncheck the corresponding option. We must select the Remove All Subtotals Option to remove Subtotals in Tableau.

Remove All Totals and subtotals in Tableau 9