Aggregates question

Let's say I have this data set

Country Quant
USA 100
UK 50
USA 25

How would I get a sum of just the USA quantites while keeping all entries in the details section?

Assuming this is a table, you would put the following conditional aggregation expression into the table footer:
=Sum( iif(Fields!Country.Value = "USA", Fields!Quant.Value, 0))

Only if country = USA, the quantity values will be aggregated. Otherwise 0 will be added.

-- Robert

|||You sir are a gentleman and a scholar.

That worked thanks!