I have performed the task at 4 different levels as below:
1) Select tool used to exclude Columns "Weekly Sales" and "Store Volume"
2) Sort tool used to sort average transactions in descending order. This is to bring the highest numbers at the top of the list.
3) Filter tool used to filter data where Region="South"
4) Sample tool used to filter first 5 records in the list, and
5) Output Data tool to generate output in excel format.
solution