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.4.2
Syntax

public class TopPivotTable : IPivotTable

The TopPivotTable type exposes the following members.

Constructors

  NameDescription
Public methodTopPivotTable
Initializes a new instance of TopPivotTable instance.
Top
Properties

  NameDescription
Public propertyColumnKeys
Public propertyColumnOtherKey
Special 'other' key used for column dimensions.
Public propertyColumns
Public propertyIncludeOtherGroups
Gets or sets flag that determines whether to include into pivot table rows/columns that exceed limits as 'other' groups (true by default).
Public propertyPivotData
Public propertyRowKeys
Public propertyRowOtherKey
Special 'other' key used for row dimensions.
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.)
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

PivotTable originalPvtTbl;
var topPvtTbl = new TopPivotTable(originalPvtTbl, PercentagePivotTable.PercentageMode.ColumnTotal);
See Also

Reference