Add Totals in Tableau is the most easiest thing in Tableau 9.0, it’s just a mater of check marks. In this article we will show you, How to add totals in Tableau and this includes adding Row Totals, Column Totals, Grand Totals and Subtotals with live example. For this we are going to use the data source we created in our previous article so, Please visit Data Labels in Tableau Reports article to understand the Data Source.
Steps to add Totals in Tableau
In this example, we are going to add totals to below shown report. If you observe the below screenshot, it was just a normal table report.
To add Totals in Tableau, go to Analysis Menu and select Totals and check mark the required option. For instance, to display Rows total we have to select Show Row Grand Totals Option as shown below
Once you select Show Row Grand Totals Option, an extra Grand Total column will be added with all the row totals as shown below
In order to display the Column totals, go to Analysis Menu and select Totals and check mark the Show Column Grand Totals Option as shown below
Once you select Show Column Grand Totals Option, an extra Grand Total row will be added 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 tableau or simply, totals of nested regions. To explain this, we removed Country names from column card and added it to rows card
Add Subtotals in Tableau
To add Subtotals in Tableau, go to Analysis Menu and select Totals and check mark the Add All Subtotals Option as shown below
Once you select Add All Subtotals Option, an extra Total row will be added in the nested region to display the column totals.
Remove Totals and Subtotals in Tableau
To remove Row Grand Totals and Column Grand Total, 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 as shown below
Thank You for Visiting Our blog