Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
This is puzzling me so I hope you can help. I am trying to sort on a concat expression
Concat(distinct product_size1, ', ',product_size_alpha)
For some reason this isn't sorting by product_size_alpha though. Unless I am missing something...?!
When i try the expression above I get this output
Does the sort order within a concat expression not work when alphabetical?
Hoping someone can help because this is driving me mad !
Try this
Concat(distinct product_size1, ', ', Rank(product_size_alpha))
Error in expression
Try clicking okay to see if it gives you any output or does it just says no output displayed or something similar?
This worked for me
=Concat(DISTINCT Product_Size1, ', ', -Aggr(Rank(Product_Size_Alpha), Product_Size1))
don't think rank works in a concat?
Maybe use Dual or lob a pick(match()) in there?
It seems to have worked with Aggr()
I've used this
=Concat(DISTINCT product_size1, ', ', -Aggr(Rank(product_size_alpha), product_size1))
Still hasn't worked..
Would you be able to share a sample where this hasn't worked? Or look at what I attached and see what the difference is between what I posted and what you have
Extending Sunny's expr: Try like: Are you trying to aggr based on your Product_Size_Alpha right ?
=Concat(DISTINCT product_size1, ', ', -Aggr(Rank(product_size_alpha), product_size_alpha))