How can I sort by a column that is included in a new{} section of a LINQ query?

Question

The following uses the Northwind database and lists out product groups with four columns: lowest, highest, average, and total price.

How can I sort by total price?

var products = from product in Products
group product by product.Supplier into groupedProducts
//orderby groupedProducts.Key.TotalPrice;
select new
{
    groupedProducts.Key.CompanyName,
    LowestPrice = groupedProducts.Min(p => p.UnitPrice),
    HighestPrice = groupedProducts.Max(p => p.UnitPrice),
    AveragePrice = groupedProducts.Average(p => p.UnitPrice),
    TotalPrice = groupedProducts.Sum(p => p.UnitPrice)
};
//order by groupedProducts.Key.TotalPrice;

Answer 1

This should work:

var products = (from ... ).OrderBy(item => item.TotalPrice);

Answer 2

How about this?

var products = from product in Products
               group product by product.Supplier into groupedProducts
               let totalPrice = groupedProducts.Sum(p => p.UnitPrice)
               orderby totalPrice
               select new
               {
                   groupedProducts.Key.CompanyName,
                   LowestPrice = groupedProducts.Min(p => p.UnitPrice),
                   HighestPrice = groupedProducts.Max(p => p.UnitPrice),
                   AveragePrice = groupedProducts.Average(p => p.UnitPrice),
                   TotalPrice = totalPrice
               };