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

       

      Result

       

       

      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?