How do I create a gap to goal dashboard?
Hi
I currently have a spread sheet that represents my gap to goal (quota)
Is there a way I can build a custom dashboard to replace this spreadsheet?
I have three categories: Commit, Strong BC and BC with a third table for “pipeline deals”
Within these tables are: Account name, FCST status, TYPE of Deal, ACV, TCV and notes and comments
Below all this I of course have a final table: Rep Quota for the QTR, Totals for Strong BC, BC and Commit, along with a percentage of forecast.
I assume if each rep has this a manager can see a roll up of all the numbers into an easily readable format
I have browsed up and down and can not find an easy to follow guide on how to build something like this.
