Aspose::Cells::Pivot::PivotField::GroupBy method

PivotField::GroupBy(double, bool) method

Automatically group the field with internal.

void Aspose::Cells::Pivot::PivotField::GroupBy(double interval, bool newField)
ParameterTypeDescription
intervaldoubleThe internal of group. Automatic value will be assigned if it’s zero,
newFieldboolIndicates whether adding a new field to the pivottable.

See Also

PivotField::GroupBy(const Date&, const Date&, const Vector <PivotGroupByType>&, double, bool) method

Group the file by the date group types.

bool Aspose::Cells::Pivot::PivotField::GroupBy(const Date &start, const Date &end, const Vector<PivotGroupByType> &groups, double interval, bool firstAsNewField)
ParameterTypeDescription
startconst Date&The start datetime
endconst Date&The end of datetime
groupsconst Vector <PivotGroupByType>&Group types
intervaldoubleThe interval
firstAsNewFieldboolIndicates whether adding a new field to the pivottable. Only for the first group item.

ReturnValue

False means this field could not be grouped by date time.

See Also

PivotField::GroupBy(double, double, double, bool) method

Group the file by number.

bool Aspose::Cells::Pivot::PivotField::GroupBy(double start, double end, double interval, bool newField)
ParameterTypeDescription
startdoubleThe start value
enddoubleThe end of value
intervaldoubleThe interval
newFieldboolIndicates whether adding a new field to the pivottable

ReturnValue

False means this field could not be grouped by date time.

See Also

PivotField::GroupBy(const Vector <CustomPiovtFieldGroupItem>&, bool) method

Custom group the field.

bool Aspose::Cells::Pivot::PivotField::GroupBy(const Vector<CustomPiovtFieldGroupItem> &customGroupItems, bool newField)
ParameterTypeDescription
customGroupItemsconst Vector <CustomPiovtFieldGroupItem>&The custom group items.
newFieldboolIndicates whether adding a new field to the pivottable

ReturnValue

False means this field could not be grouped by date time.

See Also