1 Reply Latest reply on May 31, 2016 11:38 PM by Jason Cheung

    Creating a percentage of target

    Jason Cheung



      I have searched around and can't find an answer.  I try not to abuse this forum too much.   So I am trying to create a similar dashboard like this http://public.tableau.com/views/ExecutiveSalesforce/SalesPerformance?:embed=y&:loadOrderID=5&:display_count=yes&:showTab…


      But I want to add a % of Target to the dashboard.   For example, if QTD sales is $4.98M and my quarterly target is $10M, then I am at 49% of target.  The $10M target is fixed for the quarter but is different for each quarter.   I have looked around and don't know where I can do that calculation.  Thank you all for your help!