Good morning
I have two data sets that i am trying to link and seems like i cannot link as i have many to many relationships.
Trying to acheive if Cluster and or owner filtered,
return sum of Total based on owner
Some "names" have many cost centres so it needs to be filtered to the team leader based on the clients # and cost centre 🙂
| Name | Cluster | Owner | Location | Property | Manager | # | Cost Centre |
| Bart Simpson | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 123456 | MIR |
| Bart Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 123456 | BEA |
| Bart Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 123456 | IND |
| Lisa Simpson | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 789123 | MIR |
| Lisa Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 789123 | BEA |
| Lisa Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 789123 | IND |
| Bugs Bunny | Brisbane | Bob Smith | 1 | GHI | Tom Cruise | 987654 | MOO |
| Elmer Fudd | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 654789 | MIR |
| Elmer Fudd | Sydney | John Harvey | 1 | JKL | Nicole Kidman | 654789 | RIT |
| Elmer Fudd | Sydney | John Harvey | 1 | MNO | Jane Fonda | 654789 | WYN |
| Name | # | Product code | Cost centre | Total |
| Bart Simpson | 123456 | 01_017_0107_1_1 | BEA | $ 40,515.28 |
| Bart Simpson | 123456 | 04_104_0125_6_1_T | IND | $ 26,640.64 |
| Bart Simpson | 123456 | 04_170_0136_6_1_T | MIR | $ 17,250.00 |
| Bart Simpson | 123456 | 04_105_0125_6_1_T | IND | $ 9,374.56 |
| Bart Simpson | 123456 | 04_102_0125_6_1_T | IND | $ 854.10 |
| Bugs Bunny | 987654 | 04_104_0125_6_1_T | MOO | $ 96,060.00 |
| Bugs Bunny | 987654 | 01_801_0115_1_1 | MOO | $ 28,125.71 |
| Bugs Bunny | 987654 | 01_802_0115_1_1 | MOO | $ 62,335.00 |
| Bugs Bunny | 987654 | 01_804_0115_1_1 | MOO | $ 33,218.80 |
| Bugs Bunny | 987654 | 01_805_0115_1_1 | MOO | $ 42,837.86 |
| Bugs Bunny | 987654 | 01_806_0115_1_1 | MOO | $ 13,654.16 |
| Bugs Bunny | 987654 | 01_832_0115_1_1 | MOO | $ 31,354.34 |
| Bugs Bunny | 987654 | 01_819_0115_1_1 | MOO | $ 7,628.00 |
| Elmer Fudd | 654789 | 04_104_0125_6_1_T | RIT | $ 23,310.56 |
| Elmer Fudd | 654789 | 04_170_0136_6_1_T | WYN | $ 16,560.00 |
| Elmer Fudd | 654789 | 01_801_0115_1_1 | RIT | $ 15,194.35 |
| Elmer Fudd | 654789 | 01_802_0115_1_1 | RIT | $ 62,335.00 |
| Elmer Fudd | 654789 | 01_804_0115_1_1 | RIT | $ 34,128.90 |
| Elmer Fudd | 654789 | 01_805_0115_1_1 | RIT | $ 44,011.50 |
| Elmer Fudd | 654789 | 01_806_0115_1_1 | RIT | $ 7,473.86 |
| Elmer Fudd | 654789 | 01_832_0115_1_1 | RIT | $ 23,856.56 |
| Elmer Fudd | 654789 | 04_170_0136_6_1_T | MIR | $ 16,560.00 |
| Elmer Fudd | 654789 | 06_431_0131_2_2 | RIT | $ 5,800.74 |
| Elmer Fudd | 654789 | 04_122_0136_6_1_T | MIR | $ 240.25 |
| Elmer Fudd | 654789 | 04_121_0136_6_1_T | MIR | $ 186.30 |
| Elmer Fudd | 654789 | 01_819_0115_1_1 | RIT | $ 9,696.00 |
| Elmer Fudd | 654789 | 04_112_0136_6_1_T | RIT | $ 403.84 |
| Lisa Simpson | 789123 | 04_104_0125_6_1 | IND | $ 51,725.44 |
| Lisa Simpson | 789123 | 01_011_0107_1_1 | IND | $ 38,794.08 |
| Lisa Simpson | 789123 | 01_013_0107_1_1 | IND | $ 54,606.24 |
| Lisa Simpson | 789123 | 04_170_0136_6_1 | MIR | $ 16,788.00 |
| Lisa Simpson | 789123 | 04_111_0136_6_1_T | IND | $ 1,075.80 |
| Lisa Simpson | 789123 | 01_026_0115_1_1 | BEA | $ 39,880.56 |
| Lisa Simpson | 789123 | 04_113_0136_6_1_T | IND | $ 455.63 |
| Lisa Simpson | 789123 | 04_103_0125_6_1_T | IND | $ 423.36 |
