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

[sasiparupudi1]

This?

[#3]

appears both without selection

like this:

Dim  Sum (apple)   Rownum

A             5                 1                            

B             22                 2

C             4                 3

without D because it doesn't have apple; and A,B,C only for apple figures

[sasiparupudi1]

ok Please try this

[#5]

you attached something?

many thanks

[sasiparupudi1]

no,the expression is different. It is set to only show apple irrespective of the selections of the fruit list box