Skip to Content
author's profile photo Former Member
Former Member

How to Pick the Maximum Sale Quantity and Maximum Sales Value

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2007 at 02:25 PM

    Hi Satish,

    Use the Exception Aggregation in the KeyFigure Properties and set to Maximum Value with reference Characteristic Calday or as per your requirement.

    Thnx,

    Suresh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 05:15 AM

    Can you explain what is the criteria to pick up in random?

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.