• Bernard

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

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.

Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.