8 Replies Latest reply on Jun 14, 2018 11:41 AM by Nathalia Alvarenga

    How to get total sum of previous year results YTD in the Title of the Dashboard?

    Nathalia Alvarenga

      I need to add in the title of dashboard a dynamic total sum of Cost of Delay from the previous year YTD without impacting the current information. At the moment, I have the sum for 2018 YTD (from January until May). But I need the same period result for 2017.


      I have calculated the 2018 as below:


      TOTAL(SUM(IIF([Year]=2018, [Cost of Delay (USD)],0)))


      But I cant seem to find the calculation for 2017, the closest I found was the one below:


      TOTAL(SUM(IIF([Year]=2017, [Cost of Delay (USD)-18],0)))


      I have tried the suggestions on different posts but it doesn't seems to work as well


      I have managed to get the results as table calculation but I really need the formula behind the result. Is there a way to figure out how tableau is calculating the results for 2017?