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.
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