4 Replies Latest reply on Aug 23, 2018 11:42 PM by Zhouyi Zhang

    Grouping in Calculation

    raman.singh.8

      Hi All,

      Below is my data. I need to take the max date for an ID and the amount in that row.

      For example- for "aa" ID 16-03-2018 and "7" amount should come.

       

      Presently when i am doing it in Tableau. for "aa" ID I am getting max date but the amount is coming as SUM even though only MAX date is showing up for the ID thus for aa it is showing-  18(5+6+7) and 16-03-2018 as date.

      How can we do this? Kindly advise.

      Appreciate you help

        

      IDAmountDate
      aa514-03-2018
      aa615-03-2018
      aa716-03-2018
      bb817-03-2018
      bb918-03-2018
      cc1119-03-2018
      cc1220-03-2018
      cc1321-03-2018