Report header/details/footer with counts on a Where statement

To try to make my question a little better look at it like this:


Server / User / DateTime / Action

Row 1: miami1 / carlosj / 05-04-2010 11:23:31 / Exported source
Row 2: miami1 / davidc / 05-04-2010 11:24:41 / Ran DB import
Row 3: denver7/ carlosj / 05-04-2010 11:27:29 / Exported source
Row 4: miami / carlosj / 05-04-2010 11:41:21:21 / Ran DB import

I need to have all of the servers grouped in my report grouping in the header.

Under each grouping I need several totals for exampe: total count of action where action = Exported source

But I don’t want to write a separate query for each total for each server, I want the query based on action=exported source AND where server=whatever group we are on

Can Cognos know that I am on the server group miami and pull the count for action where = exported source?