I would like to have an incremental number for each row of data. I would get as output a column where the first row would have the value 1 and the last row would have the total of rows. Any ideas about how could I do this?
I'm using SSAS 2000, so I can't use the function CurrentOrdinal .
Thanks in advance for any help.
View Complete Post