Group By And Find The AVERAGE

Input collection: myTravelExpenses10

Date	Item	Value
1/1/2020	Hotel	1050
1/1/2020	Food	30
1/2/2020	Food	75
1/3/2020	Hotel	1300
1/3/2020	Food	50
1/4/2020	Flight	800

Output collection: mySolution10

Item	Average Value
Hotel	1175
Food	51.66666667
Flight	800

Solution code:

//Create a collection
ClearCollect(myTravelExpenses10,
{Date: Date(2020,1,1), Item: "Hotel", Value: 1050},
{Date: Date(2020,1,1), Item: "Food", Value: 30 },
{Date: Date(2020,1,2), Item: "Food", Value: 75 },
{Date: Date(2020,1,3), Item: "Hotel",Value: 1300},
{Date: Date(2020,1,3), Item: "Food", Value: 50},
{Date: Date(2020,1,4), Item: "Flight", Value: 800}
);

//Group by and average code
ClearCollect(
    mySolution10,
    DropColumns(
        AddColumns(
            GroupBy(myTravelExpenses10,"Item","GroupedItems"),
        "Average Value",Average(GroupedItems,Value)
        ),
    "GroupedItems"
    )
);