1

[martinpohl]

create an inline table:

Sort_order:

load

dual(Text,Sort) as Region;

load * inline [

Text,Sort

East,1

West,2

South,3

North,4

];

So your Region field is dual, text to show, sort number to sort by.

It's like a month, jan = 1, feb = 2 and so on...

Regards

[jgreen95]

I need to be able to sort by the Pass % not by the number associated to the region

[Aditya_Chitale · Accepted solution]

Hi,

Under the sorting tab, select 'sort by expression' option and pass your % expression in it

Regards,

Aditya Chitale

[martinpohl]

maybe something like

avg(total <Region> [Pass%])

as I unterstand that there are many values for Region / Subregion