AdaptTable for Reka UI

Pivot tables in Reka UI

Grouping answers “what is the total per team”. A pivot answers “what is the total per team per status”, and that second dimension becomes columns your data never had.

Fields move between the three zones with buttons rather than drag, so the pivot can be built from the keyboard. Subtotals close every group and a grand total closes the table.

The configuration — axes, measures, aggregation and what you folded — lives in the URL, so a pivot you build is a pivot you can send someone.

The code

<script setup lang="ts">
import { computed } from "vue";
import {
  pivot, pivotTableModel, usePivotUrlState, type PivotField,
} from "@adapttable/vue/pivot";
import { DataTable } from "@adapttable/reka-ui";
import { pinnedSummaryRows } from "@adapttable/reka-ui/pinned-summary-rows";
import { PivotPanel } from "@adapttable/reka-ui/pivot";

const props = defineProps<{ rows: readonly Person[] }>();

const fields: readonly PivotField[] = [
  { key: "team", label: "Team" }, { key: "status", label: "Status" },
  { key: "budget", label: "Budget" },
];
const state = usePivotUrlState({
  urlKey: "p",
  defaultConfig: {
    rows: ["team"], columns: ["status"],
    measures: [{ key: "budget", agg: "sum" }],
  },
});
const model = computed(() => pivotTableModel(
  pivot(props.rows, state.config.value, { collapsed: state.collapsed.value }),
  { fields },
));
</script>

<template>
  <PivotPanel
    :fields="fields" :config="state.config.value"
    :on-change="state.onConfigChange"
  />
  <DataTable
    :data="model.rows" :columns="model.columns" :row-key="model.rowKey"
    :features="[pinnedSummaryRows(model.pinnedRows ?? {})]"
  />
</template>

Install

pnpm add @adapttable/reka-ui @adapttable/vue @adapttable/core reka-ui

The same feature in the other kits

• Pivot tables in Vue Unstyled — Native elements — your own CSS
• Pivot tables in Element Plus — Element blue, crisp form controls
• Pivot tables in Vuetify — Material Design, Vuetify blue
• Pivot tables in Naive UI — Clean, compact, green accent
• Pivot tables in shadcn-vue — Monochrome, ring focus
• Pivot tables in Nuxt UI — Tailwind-native, Nuxt green
• Pivot tables in Quasar — Material-flavoured, Quasar blue

More Reka UI features

• Filtering in Reka UI — Ranges, selects, an AND/OR tree and chips — all in the URL.
• Column management in Reka UI — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in Reka UI — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in Reka UI — A set of ids that survives paging, with bulk actions over it.
• Rows in Reka UI — Pin rows from a 3-dot menu, and merge a team that runs down the page.
• Row reordering in Reka UI — Drag or keyboard moves, announced — the host writes.
• Inline cell editing in Reka UI — Native editors in the cell; every write goes through your handler.
• Row grouping in Reka UI — Drag, select or keyboard grouping, with totals in the headers.
• Aggregation in Reka UI — Footer totals, pinned summaries, group aggregates — not data rows.
• Nested tables in Reka UI — A real table under a row — same engine, own columns, own keys.
• CSV export in Reka UI — One toolbar button, a CSV of the table as it stands.
• Row and column virtualization in Reka UI — 40,000 rows in a scroll box, only the visible ones rendered.
• Tree data in Reka UI — Nesting, chevrons, lazy children, and a tree on phones.
• Mobile cards in Reka UI — Every row becomes a card on phones. Automatically, with the same state.
• Saved views in Reka UI — Name an arrangement and restore it from the menu.
• Spreadsheet formulas in Reka UI — ROUND, POWER, SQRT, IF — computed columns, errors in the cell.
• Right-to-left Reka UI data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in Reka UI — Rows change while you read them. Sort and selection hold.
• Accessible Reka UI data table — Arrow-key focus, a visible ring, forced-colors, and live announcements.
• AI table assistant in Reka UI Vue — Local sort, questions and approved edits with real table outcomes.

Reference: pivot. More of this kit: AdaptTable for Reka UI, or the live demo.