Hier ein Beispiel wie man mit TSQL und "case when" schnell und einfach Monatsübersichten erstellen kann:
SELECT jahr as 'Year',
sum( case when periode = 1 then netto else 0 end) as 'Jan.',
sum( case when periode = 2 then netto else 0 end) as 'Feb.',
sum( case when periode = 3 then netto else 0 end) as 'Mar.',
sum( case when periode = 4 then netto else 0 end) as 'Apr.',
sum( case when periode = 5 then netto else 0 end) as 'May',
sum( case when periode = 6 then netto else 0 end) as 'Jun.',
sum( case when periode = 7 then netto else 0 end) as 'Jul.',
sum( case when periode = 8 then netto else 0 end) as 'Aug.',
sum( case when periode = 9 then netto else 0 end) as 'Sep.',
sum( case when periode = 10 then netto else 0 end) as 'Oct.',
sum( case when periode = 11 then netto else 0 end) as 'Nov.',
sum( case when periode = 12 then netto else 0 end) as 'Dec.',
sum(netto) as 'Total'
FROM tabelle
group by jahr
ORDER BY jahr desc