Hi,
I am looking for some help with how to only extracts duplicate rows based on a particular field in cognos 11.0.11.

Example, 
I have a field CLM, need to pull all records with duplicate values in that field.

------------------------------
Amaresh Gowda
------------------------------

#CognosAnalyticswithWatson

Create a query with two data items. One for CLM and the other (let's call this data item "CLM-Count") with this expression:

count(rows for [CLM])​

Then add this detail filter:

[CLM-Count] >= 2​

And set this filter as "After Auto Aggregation". This should give you (in a list) which CLM values are repeated.

------------------------------
Alex Santamarta
------------------------------