Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks, but I need also hide all rows with null values.
Thanks, but instead P1, P2 ... could be another values of dimension and only with text.
Try this attachment file,
Hi Dzimitry, Have you tried my answer?
Thanks.
Unfortunately I can't use RowNo() function for this because using the function automatically disabled this checkbox functionallity in 11.2 SR13 version.
Yes I gave tried, bur in the dimension field could be any values without "P" and numbers.
Hi Dzimitry, you need change Purgechar(Product,'P') with the real values that defines the order.
Regards
Could you please provide example? for: Milk, Bread, Meat ... values of dimension?
How do you will order this dimensions?
Load order for example