If I am counting presentations given per week. But my table has some presentations with two date values in error, how do I get the count to only show in one week. Preferably the earliest date? Below is a sample table. SOme of the counts each week are overstated because my data might have two week dates listed for a presentation. Thanks!
count
({$<PresentationType = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}, HouseholdMember = {'Primary'}>} Distinct PresentationID)
Week Presentation Given
07/05/2012 1,898
07/12/2012 1,959
07/19/2012 2,063
07/26/2012 1,929
08/02/2012 2,033
08/09/2012 1,943
08/16/2012 1,933
08/23/2012 2,040
08/30/2012 1,938
09/06/2012 1,712
09/13/2012 1,851
09/20/2012 1,968
09/27/2012 2,020
10/04/2012 1,923
10/11/2012 1,773
10/18/2012 1,928
Presentation
Given |
| 07/05/2012 | 1,898 |
| 07/12/2012 | 1,959 |
| 07/19/2012 | 2,063 |
| 07/26/2012 | 1,929 |
| 08/02/2012 | 2,033 |
| 08/09/2012 | 1,943 |
| 08/16/2012 | 1,933 |
| 08/23/2012 | 2,040 |
| 08/30/2012 | 1,938 |
| 09/06/2012 | 1,712 |
| 09/13/2012 | 1,851 |
| 09/20/2012 | 1,968 |
| 09/27/2012 | 2,020 |
| 10/04/2012 | 1,923 |
| 10/11/2012 | 1,773 |
| 10/18/2012 | 1,928 |
