KNOWLEDGE BASE

How to move Row Grant Totals column from right to the middle of the table


Published: 03 Mar 2022
Last Modified Date: 04 Mar 2022

Question

How to move Row Grant Totals column from right end of the table to the middle.

Before:
User-added image

After:
User-added image

Environment

  • Tableau Desktop

Answer

-Show Row Grant Totals-
 1. Connect to Sample-Superstore
 2. Drag [Category] to Rows.
 3. Drag [Sales] to table.
 4. Drag [Profit] to table.
 5. Drag [Region] to Columns.
 6. Click "Analysis" on the toolbar. > Totals > Show Row Grant Totals

 *Now the total should appear on the right side of the table.

-Move Row Grant Totals to inside of table from right-
 7. Double click on Columns and type "" in the space was shown.
     User-added image
 8. Move [""] to the leftmost Columns.
     User-added image
 9. Click "Analysis" on the toolbar. > Totals > Add All Subtotals.
 10. Right click [""] > Show Header
 11. Click on Grand Total in the table and > Remove
     User-added image

 *Now the total should be displayed inside of the table.
 

Additional Information

Optional steps
 *If multiple fields are placed on the row shelf, the column totals should also be displayed.
   User-added image
  If you wish to hide column totals, please follow the steps below.
     
 12. Right-click on the left-most field in the row shelf > Click on Subtotals.
       
      *Make sure the column totals have disappeared.
       User-added image
   
 
Did this article resolve the issue?