Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI guys,
I have a straight table with, a lot of expression and dimension, and I need to sort this fields
-My dimensions have conditional expressions
-The dimensions are showing by selected fields in the list
-The expressions are showing by selected fields in the list
The rank is created by %
I don't know why the behavior is different
In the sort tab, I select the numeric asc to RANK and numeric desc to %
Just for 1 dimension, I created the sort by expression and this dimension is the last field in the sort tab
I put here two rank expression used to calculate the rank, but with a different result.
How can I do this sort?, I don't know why this doesn't work.
one update my expression are using the conditional for define what total use in the straight table..for example
if(rowno()=0, total_1, expressionvalue)
When I removed the conditional the sort works fine, what can I do to solve the problem with this conditional?