I want to count rowno by dimension please suggest.
Output will be like below:
AutoNumber(RowNo(), [Item(Dimension)]) as nbr
(ooxml, embedded labels, table is Sheet1);
There is our expected results:
Can we achieve this using expression in a table?
a) I am assuming your are using Straight Table,
Expression for RowNo: Aggr(RowNo(),Dim1,Dim2)
b) If you are using normal Table, you have to use RowNo()/RecNo() in Load script.