U can use the reports module for this. First click on host then sql add CREATE FUNCTION [dbo].[udf_UserProfileField]
(
@PropertyName NVARCHAR(50)
)
RETURNS @ProfileFieldTable TABLE
(
PortalId INT,
UserID INT,
PropertyName NVARCHAR(50),
PropertyValue NVARCHAR(3750)
)
AS BEGIN
INSERT INTO @ProfileFieldTable
SELECT PPD.PortalID,
UP.UserID,
PPD.PropertyName,
UP.PropertyValue
FROM dbo.Users AS U
INNER JOIN dbo.UserProfile AS UP ON U.UserID = UP.UserID
INNER JOIN dbo.ProfilePropertyDefinition AS PPD ON UP.PropertyDefinitionID = PPD.PropertyDefinitionID
WHERE ( PPD.PropertyName = @PropertyName )

RETURN
END

into the sql and press enter.
next go to a page and add the reports module. then click on settings and enter this into the sql assuming that the custom profile field that you made is named Department if it is not change everywhere below that says department and add the name of the department where it says to
SELECT
u.UserName,
u.FirstName,
u.LastName,
u.Email,
department.PropertyValue AS department
FROM
dbo.udf_UserProfileField('department') AS department left OUTER JOIN dbo.vw_Users AS U on department.PortalId = U.PortalId AND departmentl.UserID = U.UserId and department.PropertyValue = 'Department name exactly as it is from the drop down list '
click test and if it comes back ok you are good to go.
Now scroll down to active visualizer and select grid. and ckeck the box for sorting and press save.