Displaying Subtotals for Only Some Dimensions

Published: 19 Jun 2013
Last Modified Date: 24 Aug 2022


How to display subtotals for only some dimensions.


  • Tableau Desktop
  • Tableau Server


Option 1: Tableau Desktop Only

To add subtotals for only the Region field, follow the steps below.
  1. Select Analysis > Totals > Add All Subtotals.
  2. To remove unwanted subtotals, right-click Customer Segment on the Rows shelf and then click  Subtotals.
To view theses steps in action, see the video below: 

Option 2: Tableau Desktop or Web Edit

  1. Add only the dimensions that you want subtotals for to the view.
  2. Select Analysis > Totals > Add All Subtotals.
  3. Add any additional desired dimensions to the view.

Additional Information

  • "Add All Subtotals" only adds subtotals to the dimensions currently in the view. 
  • To enable "Add All Subtotals" use more than one dimension in your view.

Discuss this article... Feedback Forum
Did this article resolve the issue?