Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Double Sort in Query

Hi,

I have a report which shows Topic, Sub-Topic, and a key figure called Duration. In my query I sort Topic in Ascending order. Now, I want to sort Duration in Descending order withtin Sub-Topic only. So, the original sort on Topic should remain in effect. I tried using the SAP_BW_URL command to sort on key figures but it removes my sort on Topic.

I want my report to look like this:

Topic____Sub-Topic_____Duration

-


T1_______S2____________10

_________S4____________3

_________S5____________1

T2_______S3____________10

_________S6____________9

T3_______S1____________20

Any ideas?

Thanks!

Former Member
Not what you were looking for? View more on this topic or Ask a question