int week = 35;
var sele = from d in SelectionItems
					   orderby d.SelectionID
					   select new {
					   Sortiment = d.Selection.Name, d.ItemID, Produkt = d.Item.Name, d.Item.ReleaseDate, d.Item.ProductFormatName,
					   stol = (from slo in SelectionStorages where slo.Active == true select new{ StorageName = slo.Name,
					   Week1 = (from dee in SelectionStorageRefills where dee.Week == week && dee.ItemID == d.ItemID && dee.SelectionStorageID == slo.ID select dee.Amount).First(),
					   Week2 = (from dee in SelectionStorageRefills where dee.Week == week+1 && dee.ItemID == d.ItemID && dee.SelectionStorageID == slo.ID select dee.Amount).First(),
					   Week3 = (from dee in SelectionStorageRefills where dee.Week == week+2 && dee.ItemID == d.ItemID && dee.SelectionStorageID == slo.ID select dee.Amount).First()
					   })

					   };

					   sele.Dump();