Hi all,
I have the data sets as follows:
Project Name Needed Resource
Project A Resource A
Project A Resource B
Project A Resource C
Project A Resource D
Project B Resource A
Project B Resource B
Project C Resource A
Project C Resource B
Project C Resource D
Project D Resource B
Project D Resource C
Project D Resource D
Project D Resource E
Project E Resource A
Project E Resource B
project E Resource E
I want to set a parameter, when parameter is 2, the result is as follows:
Project Name with same resource group (resource number in the group =2) Resource Group
Project A, Project B, Project C, Project E Resource A,B
Project A, Project D Resource B,C
Project A, Project C Resource A,D
Project A, Project C, Project D Resource B,D
Project D, Project E Resource B,E
And I also want to create the table for resource number in the group =3,4,5,6...
Does anyone who know how to do it? Thanks in advance!
