1 of 1 people found this helpful
You can create a calculated field like:
SUM(IIf([Gender]='Female',[Number of Records],0))
which will only sum female records and will ignore males. You can then use this field to sort your groups.
The exact formula will depend on your data, of course.
Thank you Dmitri! I'll give it a try.