Refer to attached solution
First you use SELECT tool to remove "weekly sales and store volumes" column and also rename the "TransInYear" column to "Annual Transaction". Then, use a FILTER tool to get the Average of annual transactions for south region only using formula-{ [Region] = "South" AND Average([Annual Transaction])}. Sort the data from TRUE output to get descending value of annual transaction (average now) and then use SAMPLE tool to get First 5 rows.
Here u go
This is my solution