CrossTableTotalsIndexedTotalsCalculationMode Property

Spotfire 14.3 API Reference
Gets the indexed totals calculation mode for an expression.

Namespace:  Spotfire.Dxp.Application.Visuals
Assembly:  Spotfire.Dxp.Application (in Spotfire.Dxp.Application.dll) Version: 65.0.19510.3242 (65.0.19510.3242)
Syntax

C#
public IndexedTotalsCalculationMode IndexedTotalsCalculationMode { get; }

Property Value

Type: IndexedTotalsCalculationMode
Remarks

It is not supported to use an expression with a property as a key in the dictionary. To avoid problems with properties in expressions, you can use the 'as' part of the expression as key in the dictionary, see example below.
Examples

The following example sets the totals calculation mode for the MyProfit Measure axis expression.
crossTable.MeasureAxis.Expression = "Avg([Sales]) as MySales, Avg([Profit]) as MyProfit";

CategoryKey profitKey = new CategoryKey("MyProfit");
crossTable.Totals.IndexedTotalsCalculationMode[profitKey] = CrossTableTotals.CalculationMode.SumOfCellValues;
Version Information

Supported in: 14.3, 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8
See Also

Reference