ComponentOne FlexPivot for WinForms
C1.PivotEngine Assembly / C1.PivotEngine Namespace / PivotField Class / Range Property
Example

In This Topic
    Range Property (PivotField)
    In This Topic
    Provides the RangeInfo used to group values by a criteria.
    Syntax
    '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;
    See Also