Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we use row no . function in front end
i have to add sequence 1,2 ,3 in a chart
Yes RowNo() can be used in front end objects.
Hi,
RowNo() is also a Chart function, so you can use it in an expression to return the sequential row number (starts at 1) for the current veritical dimension. Or use RowNo(total) to get the overall sequential number.
You can use this =RowNo(TOTAL) to get what you are looking for. Please find attached a sample for your reference.
HTH
Best,
Sunny
is it possible to use it in calculated dimension
Yup, you can try this as your dimension in my above sample:
=Aggr(RowNo(), Dim)