This action adds a new column with generated group numbers. A group is defined by a column or a combination of columns. Groups are enumerated starting from 1.
Example
Before:
Province | Amount | Total Tax |
---|---|---|
ON | 1000 | 125 |
ON | 1500 | 187.5 |
QC | 2000 | 270 |
After (groups are defined by column "Province"):
GroupNo | Province | Amount | Total Tax |
---|---|---|---|
1 | ON | 1000 | 125 |
1 | ON | 1500 | 187.5 |
2 | QC | 2000 | 270 |