3 Replies Latest reply on Sep 2, 2016 9:58 AM by Railey Abdullah

    Minimum Calculation In Tableau Desktop

    Railey Abdullah

      Hi All,


      I have a requirement to get the average data for the item below :


      As you can see I have total and last month total for the data, what i need to do is to sum up all Total for the selected month and add minimum month key Last Month Total

      into it.



      I try to use the MIN function to get the Last month total as below but I cant get the data





      But when I change the Calculation I can get the data :



      Result :


      In the final result I should be able to get the average data as per below:




      Is there any workaround for this?