Order by a Grouped By Count (1 Viewer)

awoitte

Registered User.
Local time
Today, 06:47
Joined
Feb 15, 2018
Messages
10
In my report, I've grouped by Template_Id (left column), and counted all proposals (second column) based on what template_id it is under.

How can I Sort/Order by the count? I can sort by all the column names, but cannot figure out where to select the count of proposals found (in red) in the report. -Attached-
 

Attachments

  • Report.png
    Report.png
    78 KB · Views: 78

Ranman256

Well-known member
Local time
Today, 09:47
Joined
Apr 9, 2015
Messages
4,337
You would need another query to do the count.
Join the count query with the data query (on group)
Then you can sort on the count.
 

Users who are viewing this thread

Top Bottom