Sorting expression

[pawwy1415]

Hi,

I have below expression used in dimension and I want to do sorting

= pick(match(MetricID,27,31,394,398,222,224,360,364,368,372,1141,1143,154,156,160,162,213,215,380,382)

     ,'PBT','Provisions','PBT','Provisions','Income','Income','Costs','Costs','Costs','Costs','PAT','PAT',

     'Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs')

sorting should be like

Income

Costs

Provisions

PBT

PAT

RWA

I used below expression in sorting..

= pick(match(MetricID,222,224,360,364,368,372,31,398,27,394,1141,1143,154,156,160,162,213,215,380,382)

     ,1,1,2,2,2,2,3,3,4,4,5,5,

     6,6,6,6,6,6,6,6)

but it doesn't work.. it's come in below order

Total RWAs

Costs

income

Provisions

PBT

PAT

Could you please see if I am doing something wrong in sorting?

[sunny_talwar]

Do you have a sample qvf you can share?

[pawwy1415]

sorry due to data restriction, I can't share

[sunny_talwar]

Mock up data?

[pradosh_thakur]

add some dummy sample . did you check the qvf i attached. the solution is working there.

regards

Pradosh