How do you enumurate rows at each change in level of a categorical variable?
Mar 3, 2015 3:52 PM(1259 views)
Refer to "Formula/Outcome" column which is my desired outcome. What formula can I use to create a sequence of numbers that restarts at each change in "composite key". In this example the "composite key" is ID and Category.