How to effect granularity of calculations & sums

[bje]

So far I have been able to have one query select items from another query performing calculations on the item.  However I realized a problem is lurking here.  I am not sure of the mechanism to force the calculation not on the entire set of data but on just the rows belonging to an individual agent.  Within SQL I would accomplish this with a 'Group By AgentID'. How do I effect this in Report Studio ? Group/Ungroup seems more about not repeating 'duplicates' in the output. The List property Grouping & Sorting seems to come after the queries are run which makes me think its not the right place either.

Thanks

[bje]

I think this answers my question:

for
Use with summary expressions to define the scope of the aggregation in the query.

Syntax
aggregate_function ( expression FOR expression { , expression } )