Sort straight table

jsobrinho — Sat, 16 Nov 2024 00:46:53 GMT

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.

Re: Sort straight table

jsobrinho — Sat, 25 Apr 2020 18:34:59 GMT

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?