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: