3 Replies Latest reply on Mar 24, 2016 5:31 PM by Shinichiro Murakami

    How to calculate Quarter to Go and Year to go

    Morgan DUARTE

      Hi there,

       

      I'm tring to build a dashboard to follow our actual revenue (Daily updated) with our monthly ambition, quarter to go and Year to go.

       

      No problem on the monthly ambition, but it is more troublesome for our quarter target and year target.

      Here is what I'm trying to calculate

       

      Today = 24th March (Actual Revenue for March is then updated)

      Jan Act = 100

      Feb Act = 50

      Mar Act = 70

      Total = 220

       

      Q1 Target = 300

       

      So to achieve Q1 Target, I need a March Target of (300 - 100 - 50) = 150

      But if I was in February, to achieve Q1 Target, I would have needed: (300 - 100)/2 (Remaining months) = 100

       

      Any idea how to do such calculation with Tableau?

       

      Attached an example of my data

       

      Thanks a lot !