Spreadsheet: 865799d1712779854-calculate-percentage-of-each-client-separately-sum-and-dynamic_range-eba
Sheet: Sheet1

CO Area | Company Code | Cycle | Text | Starting date | Ending date | Segment | Sender % | Client | Cost Element From | Cost Element To | WBS Element | Receiver % | % |  |  |  |  |  |  |  | Unique = client AGA
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 900655 | 9.09
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 9.09 |  |  | AGA920610 |  |  |  |  |  | 920610
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 202711 | 13.64 |  |  | AGA202711 |  |  |  |  |  | 202711
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 22.72 |  |  | AGA900684 |  |  |  |  |  | 900684
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 200744 | 22.73 |  |  | AGA200744 |  |  |  |  |  | 200744
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 22.73 |  |  | AGA210009 |  |  |  |  |  | 210009
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 200744 | 10.74 |  |  | AGA900673 |  |  |  |  |  | 900673
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 16.11 |  |  | AGA920678 |  |  |  |  |  | 920678
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 21.48 |  |  | AGA920651 |  |  |  |  |  | 920651
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 24.83 |  |  | AGA920676 |  |  |  |  |  | 920676
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 26.84 |  |  | AGA920693 |  |  |  |  |  | 920693
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 920610 | 4.35 |  |  | IKI930010K
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 17.39 |  |  | IKI930022K
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 21.74 |  |  | IKIXYLD01
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 26.09
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 30.43
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 5.26
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 10.53
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 10.53
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 15.79
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 15.79
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 21.05
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 21.05
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 18.18
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 18.18
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 22.72
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.7
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920678 | 9.7
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 17.58
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 24.24
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 50
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 50
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920676 | 8.7
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920651 | 17.39
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900673 | 21.74
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900684 | 26.08
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 210009 | 26.09
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.52
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 19.05
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 23.81
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 23.81
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 23.81
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920676 | 4.55
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 9.09
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 210009 | 18.18
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 22.72
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 22.73
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 22.73
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900684 | 4.55
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920676 | 13.64
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 900673 | 22.73
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920651 | 27.27
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | [NAME] | 100,00 | AGA | 410000 | 443333 | 920693 | 31.81
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 900684 | 5.26
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 900673 | 15.79
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 920651 | 21.05
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RAGA | 100,00 | AGA | 410000 | 443333 | 920693 | 57.9
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.55 |  |  |  |  |  |  |  |  | Unique = client IKI
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 9.09
1000 | 1000 | Z0123R | Text | 01.01.2023 | 31.01.2023 | Z0123RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.36 |  |  |  |  |  |  |  |  | 930022K
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 10.74 |  |  |  |  |  |  |  |  | XYLD01
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 10.74
1000 | 1000 | Z0223R | Text | 01.02.2023 | 28.02.2023 | Z0223RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 78.52
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.35
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 8.7
1000 | 1000 | [NAME] | Text | 01.03.2023 | 31.03.2023 | Z0323RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.95
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 12.5
1000 | 1000 | [NAME] | Text | 01.04.2023 | 30.04.2023 | Z0423RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 87.5
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.55
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 13.64
1000 | 1000 | [NAME] | Text | 01.05.2023 | 31.05.2023 | Z0523RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 81.81
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 19.39
1000 | 1000 | Z0623R | Text | 01.06.2023 | 30.06.2023 | Z0623RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 80.61
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 6.67
1000 | 1000 | [NAME] | Text | 01.07.2023 | 31.07.2023 | Z0723RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 93.33
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 6.67
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 6.67
1000 | 1000 | Z0823R | Text | 01.08.2023 | 31.08.2023 | Z0823RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 86.66
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 4.76
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 4.76
1000 | 1000 | Z0923R | Text | 01.09.2023 | 30.09.2023 | Z0923RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 90.48
1000 | 1000 | Z1023R | Text | 01.10.2023 | 31.10.2023 | Z1023RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 100
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 9.09
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 13.64
1000 | 1000 | [NAME] | Text | 01.11.2023 | 30.11.2023 | Z1123RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 77.27
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | 930010K | 5.56
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | 930022K | 5.56
1000 | 1000 | Z1223R | Text | 01.12.2023 | 31.12.2023 | Z1223RIKI | 100,00 | IKI | 410000 | 443333 | XYLD01 | 88.88