Hi there, the data has 4 tables, first is numerical ID which is duplicate column, second column is Item Name which is repetitive/duplicate, third column has revenue figure of the item name. Need to create a fourth column where Item name for the numerical ID be chosen in which row there is highest revenue figure.
For example, in 3 rows there is same ID 5555, but the Item Names are as below respectively.
For each ID I want to plug in the Item Name for the corresponding row which has highest revenue within an ID's group of records:
For ID 555, need to get Orange in the fourth column for the first three rows below:
ID Item Name Revenue
555 Orange 57392.68
555 Apple 2224.74
555 Orange 2373839.020
789 Mango 2829
5637 Apple 3738
221 Mango 7389
Please find the attached file for sample data and the last column 'Column to be calculated' is the field which has to be computed and the values have been inserted there
Thanks
Bookmarks