Sort value in valuelist() doesn't work

[Micki]

Hi folks i have piechart 

in which dim have Valuelist(1,2,3,4) and it's working fine.

What i want is to sort those values inside valuelsit()

Like if var = 1, Valuelist(1,2,3,4), IF var =2, Valuelist(2,1,3,4))

DOES IT POSSIBLE ? CAUSE I GET ERROR INVALID DIMENSION

[marcus_sommer]

Valuelist() could be quite tricky. Never tried to sort them because I don't use them else creating such artificial dimension within the script. The handling is much easier - means something like this:

Dim: load recno() as DIM autogerate 4;

- Marcus

[Micki · Accepted solution]

@marcus_sommer , in my case only valuelist() is ONLY acceptable solution, i did it actually found very simple solution

MATCH($(ValueList),
IF($(vPie_Chart_Sort) = 1, 'Blocked',
....))))))

working like a charm:)