Sorting issue

[gireesh1216]

Hi Team,

I am trying to sort values like below expression in sort:

Match(TYPE,'AD','FS','Pl','DB','APP','Total')

In future new values adding into TYPE filed like below. But in future also I want order first five always should be on top('AD','FS','Pl','DB','APP') and others should be last .

TYPE

AD

FS

PI

DB

APP

SO

BO

BI

SX

Total

[Anil_Babu_Samineni]

May be this?

Match(Only({1} TYPE),'AD','FS','Pl','DB','APP','Total')

[its_anandrjs]

Add another inline table table in data model

Load * inline

[

TYPE,TSortOrder

AD,1

FS,2

PI,3

DB,4

APP,5

SO,6

BO,7

BI,8

SX,9

Total,10

];

And in sort properties un check all and select sort by expression and write

=TSortOrder

Or

=Only({1} TSortOrder)

[Chanty4u]

try this in both sort tab and dimesion tab

for more  check this

order not workin

• pick(match(TYPE,'AD','FS','Pl','DB','APP','Total'),1,2,3,4,5,6)