3 Replies Latest reply on Sep 27, 2018 9:19 AM by Hari Ankem

    How to get breakup of maximum sum of two columns in a table?

    satish bhor

      Lets say we have below table structure,

       

      Table A

      columns as Dept Name, c1,c2,c3

       

      Dept Name, C1, C2, C3

      A, 9, 2, 4

      A, 0, 8, 3

      A, 5, 7,99

      B,2,3,6

      B,4,6,1

       

      output

      Dep. Name, MAX(C1+C2), C1,C2

      A,12,5,7

      B,10,4,6

       

      How Can I achieve this in Tableau?