COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: crockcw on 02 Oct 2015 12:17:43 PM

Title: Filter to look for dates that have multiple codes
Post by: crockcw on 02 Oct 2015 12:17:43 PM
I am attempting to create a report to show when an employee has 2 particular work codes attached to a date.  I have a filter to only show the 2 work codes but without the additional filter it will pull ALL data - which is quite extensive.  I do not want the data to populate unless there are multiple entries for the same day per employee.  Is there a way to create a filter that will only look for multiple dates per employee/employee ID?  I feel as if there is a simple solution to this problem and I am just not looking in the correct spot!  Any help would be appreciated.