Selection of data (programming help)

[dudden]

Hi there!
I have an issue regarding a selection of data that I want to look at. The thing is like this:
I would like to group data by counting how many contracts a customer have and show only these customers that has between 0 and 10 contracts.
I started out like this:
total(count([Contracts] )
FOR ([CustomerID])) "where total amount of contracts is between 0 and 10"

Can anyone help a lost amateur programmer...
BR Dudden

 

[sln007]

What COGNOS product are you using??

Steve N.
State of Ohio, MIS

 

[dudden]

Oops! Sorry missed that crucial part...
I am working in ReportStudio 1.1.

BR Dudden

 

[sln007]

Use a "summary" or "aggregate" filter.

Steve N.
State of Ohio, MIS