Row number by Dimension

[ramkrishna86]

Hi,

I want to count rowno by dimension please suggest.

Output will be like below:

Item(Dimension)	RowNo
A	1
A	2
A	3
A	4
A	5
B	1
B	2
B	3
B	4
B	5
B	6
C	1
C	2
C	3
C	4

Thanks

[MindaugasBacius]

Directory;
LOAD [Item(Dimension)], 
     RowNo,
     AutoNumber(RowNo(), [Item(Dimension)]) as nbr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

There is our expected results:

[ramkrishna86]

Can we achieve this using expression in a table?

[PradeepReddy]

a) I am assuming your are using Straight Table,

Dimensions: Dim1,Dim2

Expression for RowNo:  Aggr(RowNo(),Dim1,Dim2)

b) If you are using  normal Table, you have  to use RowNo()/RecNo()  in Load script.

Regards

Pradeep