Hi! I would really appreciate your help in this:
I am trying to create a report which will be grouping the projects according to the Stage. However, in some cases there are projects with the same exact name, apart form an extra CC1 added. In this case the CC1 shows an extra addition to the project but the users just create another project. Those two projects most of the times are in a different Stage. However, I was asked to create report that even though will group the projects by stage, it will keep those changed projects in the same stage group ignoring its actual stage.(Please see picture attached). Then in order for them to be able to track the actual stage of the project I have to add the stage field again. I hope this makes sense.. I would rather do that with a query but haven't figured out a way..