Problem with sorting by expression in pivot table

[Anonymous]

Hi,

I have a pivot table that consists of 5 dimensions and a couple of expressions... I have 2 dimensions expanded by default which are sorted properly by alphabetical order.

I have some problems with my other 3 dimensions, which I want to sort descending by sum(Sales), that is one of my expressions in the same pivot table. Why can't I get this work? (image attached, it's the corrent dimension - swedish)

Also, I would like to know if it is possible to sort interactive in a QlikView pivot table? So that I can switch between descending and ascending in the column head...

Thanks in advance!

Best,

Filip

[Anonymous]

And if you wonder about the typing format, I use another expression that is confidential, that's why I wrote "Sales", which is not a field in my data model.

[Gysbert_Wassenaar]

Pivot tables are a pest when it comes to sorting on anything but numeric or text. If at all possible use a straight table instead. Pivot tables don't have interactive sort either.