Skip to content
Spreadsheet Editor

PivotColRole

type PivotColRole = {
col: number;
kind: "subheading" | "subtotal";
level?: number;
};
PropertyTypeDescription
colnumber-
kind"subheading" | "subtotal"-
level?number1-based column-field nesting level (1 = outermost), selecting the dxf tier --- see PivotRowRole.level. Column subtotals have only a first* dxf, so level affects only column subheadings. Defaults to level 1 when absent.