Hi All,
I want to generate the no against the lot no. since i have a common commision no. but in a commision no there are n no of lots so i want to generate no agaist lot no.
ex.
| Commision no | Lot no. | reuired output |
|---|
| 201282591201 | 10 | 1 |
201282591201 | 11 | 2 |
| 201282591201 | 12 | 3 |
| 201282591201 | 13 | 4 |
| 201282591201 | 14 | 5 |
| 201282591201 | 15 | 6 |
| 201282591201 | 16 | 7 |
| 201282591201 | 17 | 8 |
so every commision wise there are n no of lot no so i awnt those no based on lot no.
please find the attached sample data.
looking for help
Regards
Rohit
