RunningValuePivotTable Class

NReco.PivotData Class Library Documentation
Pivot table wrapper that calculates running value by row or column.
Inheritance Hierarchy

SystemObject
  NReco.PivotDataRunningValuePivotTable

Namespace:  NReco.PivotData
Assembly:  NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.4.2
Syntax

public class RunningValuePivotTable : IPivotTable

The RunningValuePivotTable type exposes the following members.

Constructors

  NameDescription
Public methodRunningValuePivotTable(IPivotTable, RunningValuePivotTableDirection)
Initializes a new instance of RunningValuePivotTable instance by specified IPivotTable and run direction.
Public methodRunningValuePivotTable(IPivotTable, RunningValuePivotTableDirection, Int32)
Initializes a new instance of RunningValuePivotTable instance by specified IPivotTable, run direction and measure index.
Top
Properties

  NameDescription
Public propertyColumnKeys
Public propertyColumns
Public propertyPivotData
Public propertyRowKeys
Public propertyRows
Top
Methods

  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodGetValue
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Public methodUseAggregateFunction
Use specified IAggregatorFactory as aggregator function for calculating running values.
Top
Remarks

Use this class to calculate running total (sum) or other type of running values. If pivot table has several measures it is possible to specify measure index for the running values. By default RunningValuePivotTable uses SumAggregatorFactory aggregate function. It is possible to specify another function with UseAggregateFunction(IAggregatorFactory) method.
Examples

PivotTable originalPvtTbl;
var runningTotalPvtTbl = new RunningValuePivotTable(originalPvtTbl, 
  RunningValuePivotTable.Direction.Column );
See Also

Reference