Skip to Content
0
Former Member
Sep 08, 2007 at 04:17 AM

How to Pick the Maximum Sale Quantity and Maximum Sales Value

27 Views

Dear Experts

Advance thanks to all , I have faced one Problem one of My BI report which having key figures Billing Qty , Basic Price and Rate.

For Your Detail Information i am providing 2 Scineros

Scinero - 1

BillingValue BillQty Rate

100 10 10

50 5 10

30 6 5

In this scinreo-1 the first row will it pickup i.e 100 10 10

Scinero -2

BillingValue BillQty Rate

100 10 10

120 10 12

140 10 14

In this scinero-2 the its picking randonamly according to the database fetch , but My requirement is it should pickup 3rd row i.e 140 10 14

Experts i think you will be give Valubel sugesstions to achieve this ,as it is urgent we are working with Production environment.