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

    Need help calculation on Max Date


      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 :



      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 ?