# linq query mvc

Question

i want to show data  

 like image

var multable1 = db.Cases.Include("Payer").Where(x => x.CompanyID == comid)

.GroupBy(p => new {p.Payer.PayerName,p.ReceievedDate.Value.Year })

.Select(g => new CompanyUserViewModelforavgpayer

{

PayorName = g.Key.PayerName,

receieveddate = g.Key.Year,

twothousndeighteen =(double)g.Sum(w=>w.TotalCollection),

}).ToList();

 

but my linq query show result

 

 

 

how we show result like first image using linq query