Have a table with multiple columns grouped. If I add a new group, the groups on its right get duplicated and linked. For eg. in the below table, when I create Project B & C, Task 2 & 3 are getting duplicated from Project A AND they are linked so changes to Task 2 & 3 in any Project will be reflected in other Projects too. The count of each Project (number to the right) is also wrong.
I do not want duplicates to be created nor linked. Not sure why this is happening and how to solve it.
I understand there are other schema for multiple hierarchies, but I would like to make this work, to avoid having to click into Projects or Tasks. Please help. Thanks.