Original table: ID Date Category Value 1 1/20/18 d 10 2 1/22/18 f 15 3 2/1/18 e 12 4 2/13/18 d 9 5 2/17/18 f 8 6 3/11/18 e 14 7 3/22/18 e 18 8 3/19/18 f 10 I need help finding the ID with the maximum value in each month. I want my table to look like this: ID Date Category Value 2 1/22/18 f 15 3 2/1/18 e 12 7 3/22/18 e 18
... View more