Issues Both Pipeline and closed Won opportunities are displayed in Field..STAGE.
1) Need to reduce Quota by rep in a report by close-won oppty amounts
2) Then compare pipeline/(Open opptys) to the Quota to determine the amount of opptys necessary to achieve Quote.
The challenge is that this data needs be displayed in a single report. I can't group because Pipeline and Closed won share the same field. Please Advise?
Rep: (Quota - Close-Won)= Revised Quota, (Revised Quota - Pipeline or Open Opptys) = oppty gap to Quota.