Filtering query results to return only max value

Hello experts,

What is the best way to create filter in Webi to return only the max Revenue value for each Country as shown in this example?

Country, Resort, and Revenue are dimension type.

Country Resort Revenue

France French Riviera 835,420

US Bahamas Beach 971,444

US Hawaiian Club 1,479,660

I would like my webi report to return just 1 row for the US resort with greater Revenue value:

Country Resort Revenue

France French Riviera 835,420

US Hawaiian Club 1,479,660

Your thoughts are appreciated.

Edited by: HongT on Dec 2, 2011 12:27 AM