Sorting in straight table based on dimension value

[ashis]

Hello,

I have a straight table and it has more around 30 columns , all are dimensions. There is no expression.

In dimension , we have date , daily, monthly , yearly .... and many more columns.

I want to sort desc based on these daily, monthly and yearly values using there absolute value.

So in the sort tab i use

daily in first place and in expression putting =FABS(SUM(daily))

monthly in 2nd place in the expression =FABS(SUM(monthly))

yearly in 3rd place in the expression =FABS(SUM(yearly))

Will it work ?

i see for some selection where there is no 0 value for daily and monthly , yearly column is not sorting dese wise.

Please advise.

[sunny_talwar]

Might be easy to help if you are able to share a sample

[ashis]

Hi Sunny,

Due to restriction unable to share qvw file. 

Just wanted to know , if i want to sort more than one columns( that are dimensions), is that the way to do it logically.