Sort order issue

[#1]

Hi All,

Please refer the attached QVW.

I have sorted the pivot table using expression. It is working fine when the table is in colapsed mode. When I expand the pivot column by clicking the + symbol, it doesn't work. It is not srting the table based on rating.I expect it to sort from low rating to high rating, but it is sorting in some random order.

can you help?

Regards,

Murali

[#2]

is it better?

[#3]

That works..

but what magic have you done

[#4]

Properties/ Sort tab - i defined also sort order for your 2'nd dimension.

regards

Darek

[#5]

Do you need more help, or my answer resolved your problem?

regards

Darek