Crosstab with row totals and a grand-total row

Build the finance crosstab with totals both ways:

one row per category, with revenue for each of the six months in columns dec_2025, jan_2026, feb_2026, mar_2026, apr_2026, may_2026, plus a total column summing the row;

one extra grand-total row whose category is the text 'TOTAL' and whose every column is the sum of that column over all categories.

Category rows are sorted by category; the TOTAL row comes last.

Columns

cat_monthly3 columns

columntype

categoryVARCHAR

monthDATE

revenueBIGINT

The table

18 rows · 3 columns

cat_monthlyfirst 5 of 18 rows

categorymonthrevenue

electronics2025-12-011200

electronics2026-01-011100

electronics2026-02-011300

electronics2026-03-011500

electronics2026-04-011400

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows