I want then to create a new column “Incremental”, starting at 100, and adding 100 for each similar Id & SubId, so that the above dataset after transform looks like:
I think it is more or less the same solution you need, maybe you need to concat the ID and SubID columnd before using Total. Afterwards multiply the total result with 100 with calculate tranformation, or you add in the new created column used for Total 100 instead of 1.
The first two columns there are my ID and SUBID columns, that I want to match up, and have the INCREMENTAL column (KITOPNO) be 100 or multiples of that if SUBID is duplicated within the ID.
So these data are wrong, the wanted INCREMENTAL value added to the screen clippings here: