Hi,

if Cat-A,Cat-A1,Cat-A121 are 3 levels of grouping then rownumber can be used with the scope as the groupname .

not sure how to do it without grouping if it is supposed to do so. if the category name has the order no with it(A1,A2 etc.). then can't that itself be extracted and shown?

Thanks