Sort report by =Count(*)

Lochwood

Registered User.
Local time
Today, 12:38
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.
 
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

Back
Top Bottom