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
Solved! Go to Solution.
Hint:
FILTER South
SUMMARIZE GROUP Customer & SUM Amount?
SORT SUM_Amount? Descending
SAMPLE First N Records - 5
cheers,
mark
Thank you so much Mark!! It worked for me.
have a great rest of the day.
Seema.