Sort order in Pivot table (QV 8.5)

[#1]

hello, i'm new in QV 8.5 and i'm facing a sort problem. I have 3 dimensions in a pvot table: Plant, Idvendor and VendorName. I would like to sort by Plant and VendorName but it doesn't work properly. If i change the column order and put idvendor after Vendorname it works but i would like to keep the presentation order Plant, Idvendor, Vendorname with a sort by Plant, Vendorname.

What am i missing ?

Thanks

[#2]

Hi Gilles,

In the sort tab, you can change the dimensions to. So you can change the column order there to. The layout should stay the same and the sort order changes.

Rey-man

[#3]

Hi Rey-man,

indeed, i have seen that in the sort tab i can change the order of the dimensions, but it doesn't work. Even when i demote Idvendor after Vendorname in the sort tab and then click ok, the sort doesn't work and Idvendor comes back in second position (before Vendorname) in the sort tab when i return in this screen.

Gilles

[#4]

Can you post the qvw?

I can try to fix it. I'll tell you how i did it if I succeed.

Rey-man

[#5]

Please find attached the qvw

Gilles