Filtering the row by maximum value

system · February 23, 2000, 11:00am

Hi everyone!

I have the following problem:
Query fetches prices and articles by customer. The result might look, for example, like this:

Customer Article Price

Listserv Archives (BOB member since 2002-06-25)

system · February 23, 2000, 12:26pm

Hi Petri

Just a suggestion.
In the report apply BREAK on Customer & apply RANKING on article. In Ranking select the top 1 value based on the measure price.

Regards
Naveen

Listserv Archives (BOB member since 2002-06-25)

system · February 23, 2000, 1:52pm

Hi Petri,

Best way to do this is using the rank() function in a variable (i believe it’s called like that) which gives you the rank of each row. You can then add a filter on this rank-variable.

Kind regards,

Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be

Listserv Archives (BOB member since 2002-06-25)