Skip to Content
0

How can I limit the data sets here?

May 04 at 11:39 AM

23

avatar image

Hi all,

I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem.

The table I am working on consists of two objects:

I need to limit the output to the record that has the highest value in column-2:

So, the result should look like this:

Is there a function I can use for this?

TIA,

Henning

ahbxy.png (3.9 kB)
hvf8v.png (4.0 kB)
vueef.png (3.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
May 04 at 11:49 AM
0

use max function.

=max([column2 object]) in ([Column 1object ])

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

this works quit fine when using it as a filter on a report basis - thank you!
Is it also possible to implement the same functionality in the basic query?

0