Textbox Filtering

Hi All,

I have been strruggling all day with this and im not sure there is an answer but i thought i may as well ask the experts!.

I have attached a pic of the Dataset and the Report so you can see what i am trying to do.

I would like to perform a filter on the CourseYear that comes back and based on that perform a sum on the StudentFTE column. Something along the lines of (if this was year 1)

Select sum(studentFTE) from datatable where CourseYear = 1

but i then want to put this in to the column for CourseYear 2.

If you look at the report you may have an idea of what i am trying to do.

Anyone got any ideas?
ReportScreenShot.jpg
DataScreenShot.jpg