Regarding sorting with Expression in Pivot Table

[sarfaraz_sheikh]

Dear All,

I want to sort the list by expression in pivot table. I have 2 Dimension and 4 Expression(POS,Central,Branch,Total) I want list to be sorted By total.

I tried this but not able to achive the same.look at my table bel0w before selection on Approval Related it is appearing in unsorted order as below.

but once i clicked on Approval related then list is coming in sorted order as below

I dont Want my List to be sorted on selection basis ...I want the sorted list to appear in proper manner whithout selection.

How i can achive the same. my QVW is also attached here for your reference.

Sarfaraz

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[sarfaraz_sheikh]

Dear Gysbert,

Thanks a lot for you reply....I got my resolution as expected ...However can u please explain

What is dual function ?

What is fieldIndex function ?

Sarfaraz