SQLDAXExcelPython
LeaderboardRunLifetime
groupby and mergeHard30 points

Top row in each group

Set result to Region, CustomerName and total Amount for the highest-spending customer in each region.

Hard questions are part of Lifetime and Pro. Read it here, and unlock running and checking your answer from the plans.

Show solutionLifetime

Real Python running in your browser through Pyodide, with pandas available. Nothing you type is sent to a server unless you save a score.

Python
Loading editor…

Press Ctrl+Enter or Run to see the result here.