how to display # at the top of the list in BEx report
I wonder If it is possible to display a characteristic with # value at the top of the list in a BEx report.
I have a requirement to display a list of vendors and plan a distribution factor for them. I have to display also the #-Vendor for planning a global factor. This vendor should be placed at the top of the list. The # value is normally placed at the bottom of the list though. I tried everything in the query by sorting of the text and key in ascending and descending way. But none of them has worked.
Do you have any idea how to do it? I'd really appreciate every help.
Thank you all in advance.