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
------------------------------
Original Message:
Sent: Thu April 09, 2020 10:36 AM
From: Amaresh Gowda
Subject: How to pull only duplicate rows
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