TopPivotTable Class

NReco.PivotData Class Library Documentation

Pivot table wrapper that limits table by top N rows or columns.

Inheritance Hierarchy

SystemObject
NReco.PivotDataTopPivotTable

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

Syntax

C++

Copy

public class TopPivotTable : IPivotTable

Public Class TopPivotTable
	Implements IPivotTable

public ref class TopPivotTable : IPivotTable

type TopPivotTable =  
    class
        interface IPivotTable
    end

The TopPivotTable type exposes the following members.

Constructors

	Name	Description
	TopPivotTable	Initializes a new instance of TopPivotTable instance.

Top

Properties

	Name	Description
	ColumnKeys	ColumnKeys
	ColumnOtherKey	Special 'other' key used for column dimensions.
	Columns	Columns
	ColumnTopMode	Determines top-N calculation mode: first N columns (default) or last N columns.
	IncludeOtherGroups	Gets or sets flag that determines whether to include into pivot table rows/columns that exceed limits as 'other' groups (true by default).
	PivotData	PivotData
	RowKeys	RowKeys
	RowOtherKey	Special 'other' key used for row dimensions.
	Rows	Rows
	RowTopMode	Determines top-N calculation mode: first N rows (default) or last N rows.

Top

Methods

	Name	Description
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	GetValue	GetValue(ValueKey, ValueKey)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Remarks

Use this class to limit pivot table rows and/or columns. All rows or columns that exceed specified limit are grouped into special 'other' group (default label is '...'). If underlying pivot table uses grouped labels (several dimensions for rows/columns) several 'other' groups may be produced to show correct values inside groups.

Examples

Copy

PivotTable originalPvtTbl;
var topPvtTbl = new TopPivotTable(originalPvtTbl, 
    10 /* top 10 rows */, 
    Int32.MaxValue /* no limit for columns */ );

Reference

NReco.PivotData Namespace