We have a requirement where we need to group all similar stages in one ie if there are four stages A,B,C and D .
For Stage A if there are four records then all the four columns of Stage “A” should be merged in one , and other fields should be after this.
Something like this :
Name | Count | Open | Signal | Amount | Status | |
A | ABC Pipeline | 23 | TRUE | Red | 45 | Closed |
DFC Pipeline | 45 | FALSE | Blue | 43 | New | |
New Pipeline | 67 | FALSE | Green | 34 | Ongoing | |
CDF Pipeline | 34 | FALSE | Yellow | 23 | Blocked | |
B | ABC Pipeline1 | 23 | TRUE | Red | 45 | Closed |
DFC Pipeline2 | 45 | FALSE | Blue | 43 | New | |
New Pipeline3 | 67 | FALSE | Green | 34 | Ongoing | |
CDF Pipeline4 | 34 | FALSE | Yellow | 23 | Blocked | |
New Pipeline5 | 67 | FALSE | Green | 34 | Ongoing | |
C | ABC Pipeline11 | 23 | TRUE | Red | 45 | Closed |
DFC Pipeline21 | 45 | FALSE | Blue | 43 | New | |
New Pipeline111 | 67 | FALSE | Green | 34 | Ongoing | |
CDF Pipeline41 | 34 | FALSE | Yellow | 23 | Blocked | |
New Pipeline654 | 67 | FALSE | Green | 34 | Ongoing | |
New Pipeline551 | 67 | FALSE | Green | 34 | Ongoing |