Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Match(Only({1} TYPE),'AD','FS','Pl','DB','APP','Total')
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)
try this in both sort tab and dimesion tab
for more check this