I need to create a value in a column that increments.
A simple example would be:
SomeColumn as "Some Column",
'N2-L2' AS "Plan vs Instance"
The key is, the number "2" (in 'N2-L2') needs to increment.
So, the value in the first selected row would be:
The value in the second selected row would be:
... and so on.
What is the best way to accomplish this?