I have a order list and I want to generate and rank the product with its total sales and quantity. With @tvanfosson's help, I can bring the grouped product detail with the following code, but how can I calculate and add up the total sales and quantity into each productListResult's object?

Can anyone help me with this?

Many thanks.

 var orderProductVariantListResult = productList.SelectMany(o => o.OrderProductVariantList)
                .Select(opv => new { 
                    Product = opv.ProductVariant.Product,
                    Quantity = opv.Quantity,
                    PriceSales = opv.PriceSales,
                    Sales = opv.Quantity * opv.PriceSales,
                });

        var productListResult = orderProductVariantResult
                .Select(pv => pv.Product)
                .GroupBy(p => p)
                .Select(g => new 
                {
                    Product = g.Key,
                    TotalOrderCount = g.Count()
                })
                .OrderByDescending(x => x.TotalOrderCount).ToList();