I have a report which show the closing ratio of salesperson. This is a summary report grouped by opp owner. It shows all opp for a given time period. Opportunity Record has 2 formula fields. First one(Won Counter) assigns a value of 1 if the opp is won and second one(counter) just puts in a value of 1.

The closing ratio is calculated by a formula on reports which is sum of Won counter/counter.enter image description here

enter image description here What i need is dashboard on this report but shows only the logged in user's closing ratio(subtotal of each opp owner) and the Closing ratio for the whole team(grand total). I am not sure how i can show in dashboard the close ratio for running user and get the whole teams closing ratio. Any inputs would be of great help

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.