I have a ssrs report that looks like the following ( I guess a picture is more worth) :
I want to filter the column Datum for a certain year. I also want to add another two columns for a different year (one column for the datum and one for the suiker for that year.
The table is already grouped as you can see - I want to retain this grouping, but also add a column group for the different years. I am using SQL server. Should I rather do it in SQL (and how?)