Linq表Group By Get Perecentage in each column

var data = new List<Data>
{
    new Data { Category = "A", Value1 = 10, Value2 = 20, Value3 = 30 },
    new Data { Category = "A", Value1 = 20, Value2 = 30, Value3 = 40 },
    new Data { Category = "B", Value1 = 30, Value2 = 40, Value3 = 50 },
    new Data { Category = "B", Value1 = 40, Value2 = 50, Value3 = 60 },
    new Data { Category = "C", Value1 = 50, Value2 = 60, Value3 = 70 },
    new Data { Category = "C", Value1 = 60, Value2 = 70, Value3 = 80 }
};

var groupedData = data.GroupBy(d => d.Category)
                      .Select(g => new
                      {
                          Category = g.Key,
                          TotalValue1 = g.Sum(d => d.Value1),
                          TotalValue2 = g.Sum(d => d.Value2),
                          TotalValue3 = g.Sum(d => d.Value3)
                      });

var totalValue1 = groupedData.Sum(g => g.TotalValue1);
var totalValue2 = groupedData.Sum(g => g.TotalValue2);
var totalValue3 = groupedData.Sum(g => g.TotalValue3);

var result = groupedData.Select(g => new
{
    Category = g.Category,
    PercentageValue1 = (double)g.TotalValue1 / totalValue1 * 100,
    PercentageValue2 = (double)g.TotalValue2 / totalValue2 * 100,
    PercentageValue3 = (double)g.TotalValue3 / totalValue3 * 100
});