Group with Lambda, ASP.NET MVC

Question

I have a question here. I have a action which receives two parameters, two dates. This generates a list, but in this list, the same item is repeating. wanted to be able to make a sum of money. For a better understanding, the system is garage management. So I have Vr(Vehicle Requisition - Class), Mv(Vehicle Movement - Class), and Vehicle - Class.

Class Mv

    public int Id { get; set; }

    public decimal CombustivelAbastecido { get; set; }

The class Vr(Vehicle Requisition) has the vehicle. the report I want to show, receives the two dates, initial, and final, then would show the vehicles requested in that period, a vehicle was requested more than once in that period, and had an Expense "X", so I wanted it to be more or less like this;

I have the Fuel class, which has the value and the description. The Fuel Expense, would be the sum of all Fuel Cost, which has in the class Mv(Vehicle Movement)

The way I’m doing:

public Actionresult Reportariodatadois(Datetime? dataInicio, Datetime? dataFim) {

        ViewBag.dataInicial = dataInicio;
        ViewBag.dataFinal = dataFim;

        if (dataInicio == null && dataFim == null)
        {
            var vrDb = db.VrDb.Where(v => v.DataSolicitacao >= dataInicio && v.DataSolicitacao <= dataFim).OrderBy(v => v.DataSolicitacao).ToList();
            return View(vrDb);
        }

        else
        {
            var vrDb = db.VrDb.Where(v => v.DataSolicitacao >= dataInicio && v.DataSolicitacao <= dataFim && v.Situacao == Situacao.Finalizado).OrderBy(v => v.DataSolicitacao).ToList();


            var data = dataInicio;
            var dataF = dataFim;

            var tot = db.VrDb.Sum(v => v.Mv.Consumo); //Mostra o Total gasto

            if (tot == 0)
            {
                ViewBag.Total = "0";
            }
            else
            {
                ViewBag.Total = tot;
            }

            var abastecido = db.VrDb.Sum(v => v.Mv.CombustivelAbastecido);
            if (abastecido == 0)
            {
                ViewBag.Abastecido = "0";
            }
            else
            {
                ViewBag.Abastecido = abastecido;
            }



            var TotalValorEmDinheiro = db.VrDb.Sum(v => v.Veiculo.Combustivel.Preco * v.Mv.CombustivelAbastecido);

            if (TotalValorEmDinheiro == 0)
            {
                ViewBag.TotalValorEmDinheiro = "0";
            }
            else
            {
                ViewBag.TotalValorEmDinheiro = TotalValorEmDinheiro;
            }


            return View(vrDb);
            //return RedirectToAction("RelatorioTotalPorData", vrDb);

        }

    }

This way you bring me this way

That is, you’re repeating the same vehicle. Not to mention that the expense, you’re bringing me the same thing.