You created a fully interactive OLAP pivot table from scratch in just 3 steps:
piv-sales-country-year-duckdb with Report Generation capabilitytableName (view or table) — no SQL query neededpivotTable { ... }) defines the pivot dimensions declarativelyhiddenFromAggregators controls which fields appear in the value dropdownNone because pivot tables generate their own interactive HTMLcategory_name to rows or quarter to columns for deeper drill-down
rendererName to 'Heatmap', 'Col Heatmap', 'Bar Chart', or 'Treemap' for visual analysis
<rb-pivottable> web component to embed pivot tables in your own applications