Top product by supplier

[#1]

Hi

I have two tables linked together: Suppliers and Purchases. I have a Product and Value fields in the Purchase table.

How can I write an expression that would show me the top product by supplier (having the highest sum(Value))?

Thanks

[swuehl]

Are you working on QV11 ? Than I believe two dimensions, Supplier and Product with an expression sum(Value) and a dimension limit based on largest value should do it.

[#3]

Yes I'm working on QV11, however I want to put that into a table with other expressions like sum(Value), # of purchases, last purchase date etc.

Thanks

[swuehl]

Not sure if I understand, I think you can add more expressions, the dimension limit is based on the first one (I think this one can be hided if needed).

Could you give an example of the resulting table, and maybe some lines of sample data?