Group by Userid but Sort by LastName for a Summary Report

[mma40]

How do I group by Userid but sort by LastName for a summary report? I
have tried to use LastName but it gives me the totals for all "Allen"s.
Any ideas is appreciated.

 

[Duane Hookom]

Group first by LastName and then by UserID. Use the Group Header and/or
footer from the UserID level.

 

[mma40]

Thanks, that worked