Steve Jones, 11/10/2011, 0015, Labor - Direct, 1700
Steve Jones, 11/03/2011, 0015, Labor - Direct, 2000
I want to show in a table whenever an employee charges more than one Account Name on a given Timesheet Date. I've been working on this and can't seem to get the combination of COUNT and set analysis correct to show this. Records where there is only one account name for a given timesheet date should not be shown.
I currently have this in a pivot table, but would be open to a Straight Table or even Table Box if that would help.
This indicates that in this record set the only person with more than one Charge Code on a given Timesheet Date is Joe Smith on the 11/10/2011 timesheet. He charged to both 0010 and 0015 in the same week. In the full dataset, there almost certainly will be more than one person and probably more than one timesheet for each person where there are more than one Charge Code in a timesheet date.