row number

[Anonymous]

hi,

i have strighat table.

is it possible to add in calculete dimension - row number ?

i need to show number for every row -

1

2

3

...

thanks'

yarin.

[#2]

Hi,

It is better to add it as an expression. Then you can just drag the Column in the Table using the mouse to the first place. It is not possible in a Pivot table though.

[amit_saini]

Yarin,

Try this:

RowNo() as [Serial Number]

Thanks,

AS

[maxgro]

may be

aggr(rowno(total), dim1, dim2, ....., dimn)

[Anonymous]

hi,

where i need to write it ?

[aveeeeeee7en]

use rowno(total) in your chart expression.

After doing this, drag this expression to the front by holding it's label.

Regards

Aviral Nag

[#7 · Accepted solution]

Hi,

It is better to add it as an expression. Then you can just drag the Column in the Table using the mouse to the first place. It is not possible in a Pivot table though.

[maxgro]

calculated dimension

[sudeepkm]

As Syed suggested as one expression as RowN0() to your Straight Table.

You can keep the label as Serial No. This way you can have each row in your straight table a number.

Straight table also allows dragging a column name to the left in that case the Serial Number can be the first column in your straight table.

[Anonymous]

hi,

thank you all, now i get another problem

the row num apear for all my dimention.

my table show only custumer with obligo greather than 0.

after i add the new exp. RowNo(Total) - all my custumer apear.

i try this -

if(obligo>0,RowNo(Total),0)

this isn't solve my problem.

need your help.

thanks'

yarin