Skip to main content
Question

Count Unique records

  • Jun 26, 2018 5:55 AM UTC
  • 0 replies
  • 79 views

Forum|alt.badge.img+9
I am trying to count the number of unique projects worked per month using timesheets.  A project can appear multiple times per week as well as per user.  Does QB have count if Unique?  (I created a "Month" table (Each month has many timesheets and wanted to find a way to count the number of unique projects per month)  Thanks!
This topic has been closed for replies.

Forum|alt.badge.img+14
  • Qrew Corporal
  • Jun 30, 2018 1:45 AM UTC
You should be able to achieve this by a summary report grouped by the unique-project value; and then filtered on your date ranges (which you can set each time you run the report).