How to sort data according to expression values

[sushil353]

Hi All,

i need to sort my results in pivot table according to the expression calculated.. please have a look in the table given below.. i want to sort it out according to the Total Qty in descending order from top to bottom..

Please help me out to solve this problem..

[sushil353]

Hi Experts,

Please add your experience to solve this problem.

Thanks

[its_anandrjs]

Hi,

As i understand you want to sort the chart by Total Qty Field, you need to set sort order in

Chart Properties -> Sort -> CheckMark Expression -> Select descending order from list and in below window type Total Qty Expression what ever it is and apply the conditon.

Hope this helps you

Regards,

Anand

[sushil353]

Hi Anand,

Thanks for your reply, I made changes according to your suggestion. but it is working please find the attached screenshot

[its_anandrjs]

Hi,

You need to disselect other Dimension if it is selected in sort tab.

Regards

Anand