Creating row numbers for a table report

marko_slijepcevic · August 11, 2021, 11:40am

Greetings to everyone,

is there an easy way to create (or display if exists) row numbers for a table report? A sort of a sequence or something that would do the job.

daina.tupule · August 17, 2021, 7:42am

We do not have a default option to add the row count by UI.

You can define a report specific measure and use this formula for it, though:

Sum(
Head(VisibleRowsSet(), Rank(CurrentTuple(VisibleRowsSet()), VisibleRowsSet())),
1
)

I used the default add calculated > Cumulative sum formula as inspiration for this.