2 Replies Latest reply on Jul 28, 2018 8:42 AM by Naveen B

    Freezing The Totals Column

    Tim Lynch

      The request is to freeze the row total column when scrolling.  Attached is a sample workbook.  As you scroll through the manufactures to the right, they want the total column to freeze next to the header so it is always visible.  I know Tableau should not be used like Excel but it is just one section of the dashboard.

       

      Tim

        • 1. Re: Freezing The Totals Column
          Don Wise

          Hi Tim,

          Please see newly attached and below screenshot.  If this resolves your issue, please mark it as correct so that others may find it useful in the future. Thx!  Don

           

          Screen Shot 2018-07-27 at 7.52.28 PM.png

          • 2. Re: Freezing The Totals Column
            Naveen B

            Hi Tim Lynch,

             

            check the below steps how to do it

             

            Step 1: Create a calculated field like below

             

            step 2: Click on the created calculated field and covert that to discrete

            Step 3: Drag the Calculated field next to the product Name Dimension

             

            Step 4: You can see an error like below you can ignore that that clicking ok because you are about place discrete field so that for discrete tableau wont be able to show the subtotals

             

            Step 5: You will be able to see grand total next to product dimension

             

            Step 6: After Dragging the horizontal bar

             

            Hope this detail explanation helps

             

            Kindly mark this as correct and helpful so that it will be helpful to others

             

            BR,

            NB