Pipeline Shortfall: Identify and Track (Tableau)

How much additional pipeline do I need in order to hit my target?

Track a rep’s projected progress vs. their quota, while identifying how much additional pipeline the rep needs to add in order to meet their annual quota (based on an average close rate per rep).