Get Ready For Your Tableau Certification
  • Bernard

Display Grand Totals and Subtotals in Tableau


Display grand totals and subtotals in Tableau

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

Creating a table in Tableau

To add grand totals and subtotals.

Go to Analysis menu >> Totals >> and chose grand totals and subtotals respectively

Adding grand totals and subtotals in Tableau

You can customize how these grand totals and sub-totals are computed by going to Total All Using in the same menu

Customizing grand totals and subtotals in Tableau

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

Positioning grand totals and subtotals to the top or 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.

1.png
2.png