Group by based on same criteria - see description

Hi All,

Please see data below. I have project numbers overlaping in several months, for eg project number 40 comes in both October and November. Same way project number 41 comes in both November and December.

I want to create a new column called month, which has values like Oct, Nov and Dec and whenever I filter a certain month for eg : nov, it should give me the value calculated based on sprint numbers allocated to november ie 42.

Project ID                           Month                 Velocity

39                                       Oct                        10

40                                      Oct                          15

40                                       Nov                         20

41                                         Nov                       22

41                                        Dec                            40

42                                       Dec                                   60


(1) Answer