DataEngine for .NET Standard | ComponentOne
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

    Reference

    PivotField Class
    PivotField Members