Skip to content

PivotRowRole

type PivotRowRole = object;

The style role of one pivot output row that a renderer styles differently from a plain data row, identified by its 0-based row offset from the top of the pivot’s output area (PivotTable.ref):

  • subheading: a group-label row. This covers a bare label (no aggregated data) and the subtotal-above collapsed row, where the group label and its subtotal share one row (compact, and tabular outline --- Excel’s defaults); Excel styles such top-of-group rows as headings.
  • subtotal: a dedicated subtotal row below its group.
kind: "subheading" | "subtotal";

level: number;

1-based row-field nesting level (1 = outermost).


row: number;