parameter on a group summary column

[cynwink]

I have a report that displays a list of names of both temporary and permanent employees in different departments. A field of asgn_code determines permanent or temporary. I need to display names by dept and then display the total of only permanent employees under each group. How do I get the group totals for only the permanent employees? Currently I have summary column based on count of names but then the total of all the displayed names (both permanent and temp) are included. Is there a way in a group summary column to put a parameter (i.e. count where asgn_code = 'P'). I did a separate query of the total for only permanent employees for the entire report but how do I do it within the report for a group total?

 

[nagornyi]

You may also have the query that returns perms by departlment. Just select the department in that query also as a field, and link that query to the main query qroup that has the department.