1 Reply Latest reply on Sep 28, 2018 8:53 PM by swaroop.gantela

    Create a total with set under

    Toader Toporau

           Hello guys,

       

      I have an issue while creating a layout in workbook. I have to do something like this :

       

      I dont have the total as a dimension, and if i put Grand Total, the set for in/out it wont apear under it.

       

      I have done this so far :

       

      Any help is very usefull

        • 1. Re: Create a total with set under
          swaroop.gantela

          Would be grateful for clarification on how you have arranged your table.

           

          If you are using the MeasureNames/MeasureValues,

          I think you should be able to create a new calculated field called Total

          and sum up the other measures. That should then get you the row by row

          In/Out totals.

           

          If you are using Pivoted Fields, I don't think you can add a calculated field to the Pivot.

          But you could do so in Tableau Prep.


          Would be grateful for a screenshot that includes the locations of the pills

          on the Columns and Rows shelf and on the side shelves.

           

          Please see workbook v10.3 attached in the Forum Thread.