ITableGrandTotalSubtotalMeasureValue
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Numeric cell at the **intersection of row and column subtotals + grandtotals** – the *subtotals of grandtotals*.
**Visual example**
// Column grand total + row subtotal:
| Q1 | ColSum Σ |
-----------+-----+----------+
Sum A | 100 | 220 | <- 220 is grandTotalSubtotalValue
// Row grand total + column subtotal:
| Q1 | Sum A |
-----------+-----+-------+
USA | 100 | 120 |
RowSum Σ | 180 | 210 | <- 210 is grandTotalSubtotalValue
export interface ITableGrandTotalSubtotalMeasureValue
Properties
Property | Modifiers | Type | Description |
|---|---|---|---|
ITableSubtotalColumnDefinition | ITableGrandTotalColumnDefinition | (ALPHA) Column context - subtotal column or grand-total column. | ||
number | (ALPHA) Zero-based column position in the | ||
string | null | (ALPHA) Human-readable formatted intersection total value (e.g., “$15,000.00”). | ||
(ALPHA) Row context - grand-total row or subtotal row. | |||
number | (ALPHA) Zero-based row position in the | ||
“grandTotalSubtotalValue” | (ALPHA) Discriminator literal for narrowing the | ||
(ALPHA) Raw aggregated value at the intersection of row and column totals. |
Property details
ITableGrandTotalSubtotalMeasureValue.columnDefinitionpropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Column context - subtotal column or grand-total column.
columnDefinition: ITableSubtotalColumnDefinition | ITableGrandTotalColumnDefinition;
ITableGrandTotalSubtotalMeasureValue.columnIndexpropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Zero-based column position in the data matrix.
columnIndex: number;
ITableGrandTotalSubtotalMeasureValue.formattedValuepropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Human-readable formatted intersection total value (e.g., “$15,000.00”).
formattedValue: string | null;
ITableGrandTotalSubtotalMeasureValue.rowDefinitionpropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Row context - grand-total row or subtotal row.
rowDefinition: ITableSubtotalRowDefinition | ITableGrandTotalRowDefinition;
ITableGrandTotalSubtotalMeasureValue.rowIndexpropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Zero-based row position in the data matrix.
rowIndex: number;
ITableGrandTotalSubtotalMeasureValue.typepropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Discriminator literal for narrowing the ITableDataValue union.
type: "grandTotalSubtotalValue";
ITableGrandTotalSubtotalMeasureValue.valuepropertyAlpha
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.
Raw aggregated value at the intersection of row and column totals.
value: DataValue;