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

[MK_QSL]

Dual(' A :' & Sum(Sales) & chr(10) & Sales%,Sales%)

[maxgro]

maybe (in sort tab) you can promote a dimension at the first position

and sort that dimension by expression sum(Sales)

[#4]

Hi Kailash,

Sort expression is always disabled for expression in straight table. You have to sort the dimensions based on some expression.

Hope this help,

Anosh

[mukesh24]

Hi,

u can sort u r dimension base on u r expression.

[#6]

Hello Manish,

Thank you for your response, When I use Dual(' A :' & Sum(Sales) & chr(10) & Sales%,Sales%)....I am just getting % value. Text and Sum(Sales) is not showing up in expression.

[MK_QSL]

Go to presentation tab

Tick Wrap Cell Text and Set

Cell Height 2 or 3 lines

[#8]

Hello Manish,

My actual Expression is

' A :' & Sum(Sales) & chr(10) & Sales% & "B : ' & Sum(Quantity)

I have 3 parameters to pass into dual . two sums and single %.

Dual works fine with single Sum and %.Where your solution is exactly correct. But I have two sums appended.

Thanks

[MK_QSL]

What is the base criteria for sorting?...i.e.  sales or qty?...if possible. .provide sample file

[jagan]

Hi Kailash,

In sort tab select this expression and select Expression option and give the percentage expression in the text box.

Also promote this expression to the top.

Regards,

Jagan.