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!
