order id of maximum sales

hie team,can any one help me in creating a report that displays the order id of maximum sales by creating an additional row.

ie

order id sales
5 1000
4 4000
6 9000

6

i have tried this by buildng variable,but itz givng multivalued error :cry:


Ektha (BOB member since 2004-07-26)

Hi,
Can u explain the question further (In detail).


Rajasekar :india: (BOB member since 2004-07-16)

hi raja,i am tryng to prepare a report that shows the order id of maximum sales ie by showing it in an additional row as i have shown in my previous posting.

can this be done in a BO 6.0


Ektha (BOB member since 2004-07-26)

Ekhta,

I would try defining the Sales object in the universe as a measure with the default Aggregate function “Max”.
Then in the query analyzer, try pulling that object in the where clause and see what happens.
I am not sure if it is gonna work, but give it a try.

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

I don’t think the “Max” would work, since they are asking for the ORDER_ID associated to the Max Sales. Continue watching this thread where a solution has been discussed for an identical situation.

-RM


digpen :us: (BOB member since 2002-08-15)

Funny you should say that. If I had to guess, the question is from the EXACT same poster. Both questions were submitted from the same IP address. :yesnod:


Steve Krandel :us: (BOB member since 2002-06-25)