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.6.1

Syntax

C++

Copy

public class RunningValuePivotTable : IPivotTable

Public Class RunningValuePivotTable
	Implements IPivotTable

public ref class RunningValuePivotTable : IPivotTable

type RunningValuePivotTable =  
    class
        interface IPivotTable
    end

The RunningValuePivotTable type exposes the following members.

Constructors

	Name	Description
	RunningValuePivotTable(IPivotTable, RunningValuePivotTableDirection)	Initializes a new instance of RunningValuePivotTable instance by specified IPivotTable and run direction.
	RunningValuePivotTable(IPivotTable, RunningValuePivotTableDirection, Int32)	Initializes a new instance of RunningValuePivotTable instance by specified IPivotTable, run direction and measure index.

Top

Properties

	Name	Description
	ColumnKeys
	Columns
	PivotData
	RowKeys
	Rows

Top

Methods

	Name	Description
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	GetValue
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)
	UseAggregateFunction	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

Copy

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

Reference

NReco.PivotData Namespace