Range Property (PivotField)
Provides the
RangeInfo used to group values by a criteria.
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;
