Ranking tab

[kermitt]

Hello,

I've got a table in wich I have 9 measures

ID Meas1 Meas2 Meas3...Meas9

ID_001 Value Value Value...Value

I would like for each ID take the first 3 major value in abs (because some values can be negative) to display in my graph

I'm trying with the set analysis with the rank function without succes. Does anybody can drive me to a solution ?

Warm regards.

[kermitt]

like this

in this first tab you find the value

in the second is the translation in rank

I only wan't to display the measures wich belong to the rank 1,2,3