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