About the practical question

[seemavij2020]

Hi Team,

I would like to ask for help in assisting one of the question: I have the data and have to find 5 customers with the highest average transactions in the "South" region. I am able to filter South region stuck on further steps, Any help would be much appreciated.

Please provide the contact details so that I can contact either by phone or email.

Thanking you.

Seema Wadhera

[MarqueeCrew · Accepted solution]

Hint:

FILTER South

SUMMARIZE GROUP Customer & SUM Amount?

SORT SUM_Amount? Descending

SAMPLE First N Records - 5

 cheers,

 mark

[seemavij2020]

Thank you so much Mark!! It worked for me.

have a great rest of the day.

Seema.