Max Amount Supplier

[#1]

Hi, How can I create a variable that bring the supplier ID with maximum amount in any period selected?

I need to compare the amount of each provider on the most participation has.

Example:

Max Amount Supplier

Year	Amount	ID_Supplier
2010	$100.000	123
2011	$120.000	444
2012	$110.000	999

After this I may have to make a table like this:

Year	ID_Supplier	Amount	Amount_Max_Supplier	Amount / Amount_Max_Supplier
2010	111	$20.000	$100.000	20%
2011	111	$60.000	$120.000	50%
2012	111	$33.000	$110.000	30%

Thanks!

[whiteline]

Hi.

=FirstSortedValue(ID_Supplier, Amount)