SQLDAXExcelPython
Leaderboard
groupby and mergeMedium20 points

Pivot table

Set result to a table of total Amount with one row per customer Region and one column per product Category. Fill gaps with 0.

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.