sorting on excluded value

[sijojoseph22]

Hi All,

We are using the match function Match([Fleet Value USD Band], '0-1m','1-5m','5-10m','10-25m','25-50m','50-100m','>100m') in the expression to do the sorting.

Also we are using set analaysis in the expression and and because of that the value '>100m' is greyed out and sorting not working.

Is there any option to include to correct sorting order.

Thanks,
Sijo

[Anonymous]

Is it possible to upload a sample file?

[#3]

With an example it would be easier to help you out.

[sijojoseph22 · Accepted solution]

Hi All,

Thanks for the reply, we have solved by creating a inline table with the required banding values before the data loads. And joined with the banding and given the default load order in the sort order by giving the inline table field as dimension. This has solved by issue.

Regards,

Sijo