generate values grouping wise

[#1]

Hi ,

  I want to show serial values like above , means for each group values starting from 1 .?How can i do ,please suggest

[sunny_talwar]

May be try this:

AutoNumber(RowNo(), shade) as s_index

[sunny_talwar]

Sample script:

Table:

LOAD *,

  AutoNumber(RowNo(), shade) as s_index;

LOAD * Inline [

shade

A

A

A

A

A

B

B

B

B

B

];

Output:

[#4]

Thanks sunny