In SQL I can easily create a co-related sub query, to return the maximum User_Id in each Department.
Can I do the same in an attribute view?
I tried by adding Max(User) id as a calculated field and Department as a regular field. This gave an error on activation. How do I tell an attribute view to do the equivalent of group by on the Department?