row ID function in spotfire crosstable

[Cerin Kuriakose]

Can someone please explain to me what RowID() function means in spotfire crosstable.

Consider a cross table with 2 vertical axes, 1 horizontal axes and 4 cell values.

[Khushboo Rabadia]

RowID() is the row number assigned to each row in datatable. Say you have 10 rows in datatable, the order in which the rows are present in data table accordingly they will be assigned row number.

When you use it in crosstable like first(RowsId()), it will show the row number assigned to that row in datatable. In attached image, though a-15 is first in crosstable, but that row is second when imported so it is assigned row number 2 and same is seen in crosstable.