4 Replies Latest reply on Aug 22, 2018 9:31 PM by Zhouyi Zhang

    Total Sum calculation based on a dimension

    sunny p

      How to calculate Total Sum of all values in a column based on a Dimension. I need to sum up all values separately by using a dimension.While doing sum I need to ignore negative values. How to do it in Tableau. In the attached file I need to create separate view based on user and need to show up Total time, Misc time,page cnt and code cnt columns in a single row.

       

      Screen Shot 2018-08-22 at 7.35.20 PM.png

       

       

      Screen Shot 2018-08-22 at 7.41.14 PM.png