COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Web2CRM on 02 Jul 2013 11:53:59 PM

Title: SOLVED: How to pull duplicate data only in Reports Studio
Post by: Web2CRM on 02 Jul 2013 11:53:59 PM
I have a  list report created which is supposed to pull records with duplicate data only, but it seems not to work as expected because it is also pulling unique records.  Anyone here can help me handle such situation?  Thanks in advance!!!!
Title: Re: How to pull duplicate data only in Reports Studio
Post by: CognosPaul on 03 Jul 2013 01:06:10 AM
Does your data contain a key you can use to find the duplicate data? Create a new data item with the expression 1, with the aggregate function sum. Drag that into the summary filter, scope set to your key. [Data item]> 1