0 Replies Latest reply: Jun 14, 2011 4:38 PM by 858640 RSS

    Show all users in an report, regardless of activity

    858640
      I am trying to get a report that shows all opportunities created during the week. I have about 90% of what I need. The report displays all of the converted opps, broken up by campaign, that have been created during the week you are looking at it, however I need it to list all of the other users in the system that have no opportunities created yet.

      So that if campaign A has 6 users assigned to it, but only one has converted anything. I want it to show 0's next to the other 5 reps, and a 1 next to the rep that has converted something.

      How do I get the users with no activity into the report? I have done a bit of digging into the forum and combining with similar analysis, but I can not figure it out to save my life.

      Any help is appreciated.

      Thanks

      Mike