please refer the attached solution
-
I have attached the results. Started with Select and removed the Weekly Sales and Store Volumes. Then sorted by Trans in Year descending. Then filtered by Region = South and then sampled the first 5 rows and grouped by TransinYear