Custom sort ???

[ahmar811]

hello

i have a field model as you can see below

Model
<2
Total <2
12 i
25 k
2-3
Total 2-3
29 k
26 k
3-4
29 j
26 j
25 j
Total model
Total 3-4

i want to sort it as below in pivot table

Model
<2
12 i
Total <2
2-3
25 k
26 k
29 k
Total 2-3
3-4
25 j
26 j
29 j
Total 3-4
Total model

Thanks & Regards

Ahmar

[Peter_Cammaert]

You will always have to change some code or configuration (either externally or internally) as there is no relation between the Model value and the sort order. What place will arbitrary new Model value xyz (replace with any possible value) get? If you can describe that logic, you can program a dynamic ordering solution.

Best,

Peter