[]
        
(Showing Draft Content)

C1.PivotEngine.PivotField.Range

Range Property

Range

Provides the RangeInfo used to group values by a criteria.

Declaration
public RangeInfo Range { get; }
Examples

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;