Skip to Content
0
Former Member
Dec 02, 2008 at 06:24 PM

Cross Tab - select dates

19 Views

Hi I have created a cross-tab report using only two fields. enrollment_id and create_date. What is needed is a count of the # of enrollments and a summary for the week starting on Sunday. I have been able to do this however, they only want for the previous 4 weeks - I am returning all weeks since the start. I am not sure where to filter. Here is what I used in a regular report which worked but is not working in the cross-tab. The formula below gives me up to the last 4 weeks sunday to today.

not ({ISSUANCE.CREATE_DATE}in Last4WeeksToSun) and

not ({ISSUANCE.CREATE_DATE} in WeekToDateFromSun)

Here's what it should look like and includes a count up to today for week of 11/30.

Site_name 11/02/08 11/09/08 11/16/08 11/23/08 11/30/08

#issued 25 29 16 18 15

Any help would be appreciated.