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?