Range Property

Provides the RangeInfo used to group values by a criteria.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Range As RangeInfo

public RangeInfo Range {get;}

Example

Groups the "OrderDate" column by fiscal year that begins in April.

// Fiscal year
Engine.Fields["OrderDate"].Range.RangeType = RangeType.FiscalYear;
Engine.Fields["OrderDate"].Format = "\"FY\" yyyy";
Engine.Fields["OrderDate"].Caption = "Fiscal Year";
Engine.Fields["OrderDate"].Range.FiscalYearFirstMonth = FirstMonthOfFiscalYear;
Engine.Fields["OrderDate"].Range.FiscalYearShift = 0;

Reference

C1FlexPivotField Class
C1FlexPivotField Members

Product Support Forum | Print this page