ITableGrandTotalSubtotalMeasureValue
Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production.
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.
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.
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.
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.
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.
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.
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.
Raw aggregated value at the intersection of row and column totals.
value: DataValue;