Display only the first record

[Former Member]

I have report in BEx where we want to find the first time a customer ordered Quantity of more than 500 in a data range (For Ex: From April 10 to April 30). In a particluar date range the customer may order more than once (Qty > 500). The catch is we want display only one first time he ordered qty > 500.

Customer Date Qty > 500.

ABC 4/21/2005 2,035 CA

4/22/2005 12,290 CA

4/23/2005 4,826 CA

4/26/2005 6,397 CA

4/27/2005 1,538 CA

4/28/2005 4,849 CA

XYZ 4/25/2005 2,000 CA

4/26/2005 12,000 CA

4/27/2005 4,500 CA

4/28/2005 6,300 CA

....

In the output report we want to display the first record for each customer as:

Customer Date Qty > 500.

ABC 4/21/2005 2,035 CA

XYZ 4/25/2005 2,000 CA

Your help is really appreciated. Thanks.

[Former Member]

Hi Jayant,

the issue is simple.after u set the date deadlines...what u can do is fo to conditions for that key figure and set top n and in the user input wcreen give 1....that means it only fetches the first value of the report.try this and lemme know.

ragav

[Former Member]

jayant,

i think, you could use your date as a condition to filter by in your report... try looking that the properties of your KF and, under Calculations, set the 'Calculate Result as...' to the first value only.

hope this helps - don't forget to give out points. 😃

ryan.

ps. i've tried this, and it sort of works - just need a bit more of tweaking around. 😃

Message was edited by: Ryan Kristoffer Tan

[Former Member]

Jayant, you can try to use a condition with Top N. I think that if you put TOP N = 1, will be ok. But I didnt test this.

[Former Member]

Hi,

I don't think Marcelo's solution would work if I understood the problem correctly. You can show all the records with Greater than 500 in sorted manner. But it's not possible to show only the first record. Correct me if I'm wrong.

Thanks,

Trinadha