Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dual(' A :' & Sum(Sales) & chr(10) & Sales%,Sales%)
maybe (in sort tab) you can promote a dimension at the first position
and sort that dimension by expression sum(Sales)
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
Hi,
u can sort u r dimension base on u r expression.
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.
Go to presentation tab
Tick Wrap Cell Text and Set
Cell Height 2 or 3 lines
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
What is the base criteria for sorting?...i.e. sales or qty?...if possible. .provide sample file
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.