Sorting Issue

[#1]

Hello,

I have an expression in Straight table which is appended with some text value

Example:  ' A :' & Sum(Sales) & chr(10) & Sales%

I am trying to sort my Straight table based on the Sales % value from the above mentioned expression. But the sort by expression is disabled for this expression. So I need to use dual or some logic to sort my expression.

Thankyou for your help

[avinashelite]

Hi Kailash,

Go to sort tab and select expression option > paste your sorting expression i.e. sales% here this should work!!

[#3]

Sales % is the criteria for Sorting.

[#4]

In Sort Tab, Sort by expression tab ll be disabled. So cant do that.

[#5]

In Sort Tab, Sort by expression tab ll be disabled. So cant do that.