LINQ - Group by with SUM IF

var data = new List<Person>
{
    new Person { Name = "Alice", Category = "A", Amount = 100 },
    new Person { Name = "Bob", Category = "B", Amount = 200 },
    new Person { Name = "Alice", Category = "A", Amount = 300 },
    new Person { Name = "Bob", Category = "B", Amount = 400 },
    new Person { Name = "Alice", Category = "B", Amount = 500 }
};

var result = data.GroupBy(p => p.Name)
                 .Select(g => new
                 {
                     Name = g.Key,
                     TotalAmount = g.Where(p => p.Category == "A").Sum(p => p.Amount)
                 });

foreach (var item in result)
{
    Console.WriteLine($"Name: {item.Name}, Total Amount: {item.TotalAmount}");
}

public class Person
{
    public string Name { get; set; }
    public string Category { get; set; }
    public int Amount { get; set; }
}