In this post, you will learn how to add grand totals and subtotals in Tableau.
To show this, lets first create a view (table) showing Sales for different Regions and Segments in different Years
To add grand totals and subtotals.
Go to Analysis menu >> Totals >> and chose grand totals and subtotals respectively
You can customize how these grand totals and sub-totals are computed by going to Total All Using in the same menu
By default, grand totals and subtotals are displayed at the bottom or right of the table, you can move them to the top or left by;
Right clicking on Grand total or Subtotal on the table and choose Column Totals to Top or Row Totals to Left
Alternatively, go to the Analysis menu >> Totals >> Column Totals to Top or Row Totals to Left
Resulting table after some quick formatting.
I hope this article was helpful to you. To receive more of the Tableau tips and tricks, kindly subscribe to our mailing list below.
Thank you for reading.