Sort report by =Count(*) (1 Viewer)

Lochwood

Registered User.
Local time
Yesterday, 19:48
Joined
Jun 7, 2017
Messages
130
I have a filtered report grouped by name and their competence. so if someone has 3 competencies based on the filter it shows the 3 comps under their name in the group. i Have added a =Count(*) to the name header showing their 3 comps and would like the report to order by the highest competence first. at the moment it is ordering by name. is this possible.
 

isladogs

MVP / VIP
Local time
Today, 03:48
Joined
Jan 14, 2017
Messages
18,212
Use the report sorting and grouping feature and sort by number of competencies (which needs to be a field in the report record source) then by the name
 

Users who are viewing this thread

Top Bottom