cancel
Showing results for 
Search instead for 
Did you mean: 

Double Sort in Query

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

In query designer you can set this properties on each charactestics from the context menu of it.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

I looked and I don't see it. Can you tell me exactly what the property name is that you are referring to?

Thanks.

Former Member
0 Kudos

Hi,

You can find more information about "Sorting" in the link:

http://help.sap.com/saphelp_nw04/helpdata/en/1a/25213c9cffa027e10000000a11402f/frameset.htm

i.e: Right click on the characterstics.

With rgds,

Anil Kumar sharma .P

Former Member
0 Kudos

Thanks.... I ended up creating a condition on the key figure using Top % = 100. And then applied it to Sub-Topic characteristic only.

I have another question which i will post a new topic. thanks.