8 Replies Latest reply on Apr 11, 2016 12:10 AM by Mahfooj Khan

    Tableau Calculation

    Nagaraj Koranthota

      Hi All,

       

      Please help with the below Calculation :

          

      Order

      Category

      Amount

      Total Sum

      123-1Null918
      123-1a218
      123-1b418
      123-1Null118
      123-1Null118
      123-1Null118
      456-1Null216
      456-1ab816
      456-1bc316
      456-1cd116
      456-1Null216
      777-2Null813
      777-2Null213
      777-2Null313

       

      Expected Output:

       

         

      123-1b18
      456-1ab16
      777-2null13

       

      Logic:

      • To find a category which has max amount for a given Order and show the total amount for that order.
      • Show Null in category only when don't see any non-Null category.

       

      Regards,

      Nagaraj