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

          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.