4 Replies Latest reply on Feb 16, 2018 10:13 AM by mafalda.santos

    Need help calculation on Max Date

    mafalda.santos

      Hi all,

       

      This is my original text table

       

      If my cell is null is showing previous value:

       

       

       

      But now I need to create a calculated field that show only the values for Max Month like image bellow dinamically:

       

      I used this formula :

       

      IFNULL(SUM(iif([Date]={MAX([Date])},[Values],NULL)),PREVIOUS_VALUE(SUM([Values])))

      But its not working.

       

      Instead Area B=327,2 Tableau is sum all values on that row(453.1+327.2)=780.

       

       

       

      The purpose of isolate Max Month it´s because the client wants to see only 2 collumns: One collumn with Max Month and another with diference between Max Month and Previous. Besides the second text table that I showed.

       

       

      Please if anyone can Help on this issue will be much appreciated ?

       

       

      Regards,

       

      Mafalda