Pivot

✓ functional

Build a cross-tab by moving fields around, then keep the setup as a reusable directive if you like.

Every result grid has a Pivot tab alongside Grid and Chart. Open it to turn a flat result into a cross-tab by moving fields around; the query itself stays untouched.

Building a pivot

The sidebar lists the available columns and four drop zones. Drag a field into the place where it should do its work:

Rows and Columns - the axes of the cross-tab.
Values - the measure to aggregate. The value chip carries a dropdown to pick the aggregate; it reads e.g. “Sum of Amount”.
Filters - restrict which rows feed the pivot, with a per-field value picker.

Choose from Count, Sum, Avg, Min, Max, and First. Layout options add subtotals, grand totals, and flat rows; per-field formatting handles decimals, separators, negative values, and alignment.

SQLly interactive pivot builder with drop zones — The interactive pivot: source fields and the Rows / Columns / Values / Filters drop zones, with the cross-tab rendered alongside.

Drill down

Double-click a pivot cell to return to the Grid tab filtered to the rows behind it. SQLly labels the view “Filtered from pivot” and provides a one-click Clear filter.

Wait for the full result. Pivot stays locked while a result set is streaming so it never cross-tabs a partial answer. Once the rows finish arriving, the tab unlocks. Use Save configuration for a setup you will reuse.