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.
Properties
Section titled “Properties”kind: "subheading" | "subtotal";level: number;1-based row-field nesting level (1 = outermost).
row: number;