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!
I figured it out myself. All I did was I imported another table with the targets and linked it with the sales data. Then I created a calculated field to get the %. Pretty easy actually. No wonder no one has asked this question