Table Custom Sort

[alec1982]

Hi Guys,

I have a table chart where the first dimenssion is fixed values and it is sorted text A->Z

Field1

Current Montn

Current Year

Next 5 Years

Next 10 Years

Next 30 Days

Next 60 Days

Next 90 Days

Next 120 Days

Is there anyway to do custom sort so the table will look like:

Field1

Current Month

Current Year

Next 30 Days

Next 60 Days

Next 90 Days

Next 120 Days

Next 5 Years

Next 10 Years

Thxs,

Alec

[Anonymous]

create a inline table like

load #inline

[

field you need to sort, sort order

Current Month,1

Current Year,2

Next 30 Days,3

Next 60 Days,4

Next 90 Days,5

Next 120 Days,6

Next 5 Years,7

Next 10 Years,8

];

  and drop this inline table

hope this help

[alec1982]

Hi,

May you please give me more details on where should I put this table. in the script? or on the sort tab expression?

Thxs,

[Anonymous]

in the script

[alec1982]

Oh! I just wanted to say i cannot use it in the script.

Is there anyway to cstom sort in the chart?

Thxs for your help!

Alec

[Anonymous · Accepted solution]

then use expression in the sort tab like

=match([field that need to be sorted],'Current Month','Current Year','Next 30 Days','Next 60 Days', etc)

[alec1982]

Thxs for your help!