Can I sort by a given field AND the number of records in that field? Ex: sort by employee # by most times employee stepped into a room to least?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have a report where each action is a separate recorded record by any given employee number.  Can I sort by grouping all employees by their number and have it appear highest number of recorded actions to lowest? 

Photo of Brian


  • 0 Points

Posted 3 years ago

  • 0
  • 1
No problem.

Make a report of Type Summary and in the "summarize what" field just have it count the # of records and  the rows to group by employee.

Run the report.

Click on the column with the # of records a couple times until it sorts "descending"

Save the report.