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?