Pulling of specific items based on a criteria

Hello everyone. I have a report consisting of prices. I need to pull the top ten most expensive prices. There is a Max function in BO. I can also do a descending sort. The Max function will only pull one item. How can I make it pull 10 based solely on the price? I would like to try to avoid a script.

Thank you,


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

In the Query Panel, choose the Options button. There you can specify the number of rows you want returned. This option combined with a descending sort on Price should give you what you want.

HTH<

Donald May


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

Diana;

Have you looked at the “Ranking” function? I think this will address your needs.

Bruce Hinrichs
Schneider National, Inc.
Green Bay, WI USA
HinrichsB@Schneider.Com


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

Hi Diana,
There is a ranking function that will satisfy your issue. Highlight the column that contains the prices, then apply the rankinbg to show the top 10 largest prices. everytime you refresh the report, the rank will still apply. laurenf@bellatlantic.net

Spears, Diana wrote:

Hello everyone. I have a report consisting of prices. I need to pull the top ten most expensive prices. There is a Max function in BO. I can also do a descending sort. The Max function will only pull one item. How can I make it pull 10 based solely on the price? I would like to try to avoid a script.

Thank you,


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

How can I make it pull 10 based solely on the price?

You can accomplish this from the report end or the query side …

A) Create a report variable using the Rank function OR B) Insert a ranking on a report OR
C) Build a query, sorting on the measure which you want to rank and return only the specified number of rows (ie: sort descending on price, return 10 rows)

Best Regards,
Lori Furda
Sage Solutions, Inc.
Lori_Sage@solution4u.com


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