Row Numbering

[Anonymous]

I've been looking for a built-in funtion that I could use at object-level for numbering of rows alwayd starting from 1 and increment by 1. For example:

No.      Retailer        Category     Prod   Price

1         A                 Cat1           P1      19.99

2         T                 Cat7           P9      15.99

3         M                Cat3           P5       27.99

I need column No. all the time start from 1,2,3... for any selections.

Thanks.

[Gysbert_Wassenaar]

Use the rowno(total) as an expression.

edit: In a straight table you can drag expressions to the left of any dimensions.

count(aggr(1,Dim1,Dim2,...,DimX)) will give you a count of the number of rows in an object with Dim1, Dim2,... and DimX as dimensions.

[Anonymous]

Thanks, that was close, I need this column as the first one in a straight table. Or, even if I could add in Caption total No. of rows in a resulting table that should be fine too.