Pivot sorting - help example extrange behavior

[#1]

Hello,

I'm trying to make the pivot chart to sort data on a certain way. I was reading forum cases and maybe I don't completely undertand how sorting works, but from what I've read, sorting applies for first dimension of pivot, but it doesn't seem to work.

I attach a simple example where sorting doesn't work correctly. My pivot has more additional dimensions, including conditional ones, but the behavior is the same.

As expression I've put the expression used on sorting to see the expected result.

Please, if anyone could give me a hand I would appreciate it.

Regards,

Cristian

[#2]

hi Cristian

i cant open your example please . give me a screenshot

regards

Gernan

[#3]

Hello Gernan, thanks for your interests on helping me.

Here is a picture. The expresion for sorting is the same that I used in columns "Orden".

Regards,

Cristian