Skip to Content

How can I limit the data sets here?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 04 at 11:49 AM

    use max function.

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

    Add comment
    10|10000 characters needed 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?