Can you share a packaged workbook?
It would be easier to help you with your actual data (or some mock-up).
1 of 1 people found this helpful
1st, create a calculation field as below
and then use this calculation field to create the bin. This bin will only consider the max value in each year of each ID
Hope this make sense.