row number

[#1]

hi all

I want to put in a straight table numbers for each row (1,2)

- I tried rowno() and rowno(TOTAL) but the problem is that in the expressions used in the table I excluded with set analysis couple of things from all base and row() put me all not only the selections set by me

- rank in not good because is depending from an expression and when I sort different the numbers will mix; more than that, if there are 2 2 things in dimension with the same value rank will repeat number

thanks

Cosmin

[sunny_talwar]

Have not tested this, but try this may be:

If(YourExpression1 > 0 and YourExpression2 > 0 and YourExpression3 > 0, RowNo())

[#3]

it is not working

thank you

[sunny_talwar]

What exactly are you trying to get??

If this is the sample data

Dim     Value

A          10

B          20

C          30

In your straight table you want to see A and C and another expression for RowNo like this????

Dim     Value     RowNo

A          10         1

C          30         2

[#5]

yes

like this:

A  apple   5

A peach   7

B apple   10

B  apple   12

B peach   1

C apple   4

D peach  10

and I want to make a straignt table like this:

just for apple (whith set analysis)

Dim  Sum (apple)   Rownum

A             5                 1                            

B             22                 2

C             4                 3

with simple rowno() appears also D 4

[sunny_talwar]

I am seeing this with your sample, this is not what you want?

[#7]

yes

[sunny_talwar]

What do you want then???

[sasiparupudi1]

Hi

Please see the attachement and rowno(TOTAL) seems to be giving the correct values.Is it possible to upload your application?

Sasi

[#10]

I need this but to work without selection; I see in your ex I need to select 'peach'

thanks