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.
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.
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.
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)