RowNo() alternative

[dzmitry_shmurye]

Hi community!

I am trying to create expression for generate Row numbers in the straight table but without using RowNo() function.

I have tryed to write expression like this:

RangeSum(1,Above(Rows))

But I need generate Rows values only for first fives rows in the table (P1 - P5) and for others rows it's should be Null values in the Rows expression.

Could somebody help me resolve this issue?

[dzmitry_shmurye]

Thanks, but I need also hide all rows with null values.

[dzmitry_shmurye]

Thanks, but instead P1, P2 ... could be another values of dimension and only with text.

[susovan]

Try this attachment file,

[Anonymous]

Hi Dzimitry, Have you tried my answer?

Thanks.

[dzmitry_shmurye]

Unfortunately I can't use RowNo() function for this because using the function automatically disabled this checkbox functionallity in 11.2 SR13 version.

[dzmitry_shmurye]

Yes I gave tried, bur in the dimension field could be any values without "P" and numbers.

[Anonymous]

Hi Dzimitry, you need change Purgechar(Product,'P') with the real values that defines the order.

Regards

[dzmitry_shmurye]

Could you please provide example? for: Milk, Bread, Meat ... values of dimension?

[Anonymous]

How do you will order this dimensions?

[dzmitry_shmurye]

Load order for example