I have a table with fields: Country, Seller, Amount, Discount.
How I do a graph showing for each Country, Sum(Amount) of top ten Sellers (ranking about Amount sold on that Country) and Sum(Discount) of top ten Sellers (ranking about Amount sold on that Country)?
I think it works by using rank() and aggr() commands, but I can't.