Spreadsheet: 725513d1616712114-filter-data-with-a-summary-by-defining-dynamic-space-needed-rows-without-macros-vba-power-query-to-produce-proper-data-set-talrak-
Sheet: Table1

PHASES | Attribute | Value | Text Before Delimiter
Phase 1.A | CC1 | 121 | Phase 1
Phase 1.A | CC2 | 45 | Phase 1 |  | Sum of Value |  | Attribute
Phase 1.A | CC3 | 789 | Phase 1 |  | Text Before Delimiter | PHASES | CC1 | CC2 | CC3 | CC4 | Grand Total
Phase 1.A | CC4 | 68 | Phase 1 |  | Phase 1 | Phase 1.A | 121 | 45 | 789 | 68 | 1023
Phase 1.B | CC1 | 572 | Phase 1 |  |  | Phase 1.B | 572 | 798 | 9 | 51 | 1430
Phase 1.B | CC2 | 798 | Phase 1 |  |  | Phase 1.C | 691 | 295 | 151 | 799 | 1936
Phase 1.B | CC3 | 9 | Phase 1 |  |  | Phase 1.D | 339 | 510 | 33 | 56 | 938
Phase 1.B | CC4 | 51 | Phase 1 |  |  | Phase 1.E | 808 | 196 | 418 | 500 | 1922
Phase 1.C | CC1 | 691 | Phase 1 |  | Phase 1 Total |  | 2531 | 1844 | 1400 | 1474 | 7249
Phase 1.C | CC2 | 295 | Phase 1 |  | Phase 2 | Phase 2.A | 2582 | 1128 | 3456 | 596 | 7762
Phase 1.C | CC3 | 151 | Phase 1 |  |  | Phase 2.B | 707 | 269 | 1268 | 1484 | 3728
Phase 1.C | CC4 | 799 | Phase 1 |  | Phase 2 Total |  | 3289 | 1397 | 4724 | 2080 | 11490
Phase 1.D | CC1 | 339 | Phase 1 |  | Phase 3 | Phase 3.A | 533 | 1047 | 1334 | 772 | 3686
Phase 1.D | CC2 | 510 | Phase 1 |  |  | Phase 3.B | 110 | 178 | 965 | 261 | 1514
Phase 1.D | CC3 | 33 | Phase 1 |  | Phase 3 Total |  | 643 | 1225 | 2299 | 1033 | 5200
Phase 1.D | CC4 | 56 | Phase 1 |  | Phase 4 | Phase 4.A | 292 | 337 | 644 | 986 | 2259
Phase 1.E | CC1 | 808 | Phase 1 |  |  | Phase 4.B | 175 | 536 | 580 | 994 | 2285
Phase 1.E | CC2 | 196 | Phase 1 |  |  | Phase 4.C | 682 | 697 | 547 | 267 | 2193
Phase 1.E | CC3 | 418 | Phase 1 |  |  | Phase 4.D | 846 | 639 | 738 | 400 | 2623
Phase 1.E | CC4 | 500 | Phase 1 |  | Phase 4 Total |  | 1995 | 2209 | 2509 | 2647 | 9360
Phase 2.A | CC1 | 425 | Phase 2 |  | Grand Total |  | 8458 | 6675 | 10932 | 7234 | 33299
Phase 2.A | CC2 | 129 | Phase 2
Phase 2.A | CC3 | 915 | Phase 2
Phase 2.A | CC4 | 130 | Phase 2
Phase 2.A | CC1 | 640 | Phase 2
Phase 2.A | CC2 | 202 | Phase 2
Phase 2.A | CC3 | 776 | Phase 2
Phase 2.A | CC4 | 83 | Phase 2
Phase 2.B | CC1 | 184 | Phase 2
Phase 2.B | CC2 | 23 | Phase 2
Phase 2.B | CC3 | 973 | Phase 2
Phase 2.B | CC4 | 510 | Phase 2
Phase 2.B | CC1 | 523 | Phase 2
Phase 2.B | CC2 | 246 | Phase 2
Phase 2.B | CC3 | 295 | Phase 2
Phase 2.B | CC4 | 974 | Phase 2
Phase 2.A | CC1 | 881 | Phase 2
Phase 2.A | CC2 | 702 | Phase 2
Phase 2.A | CC3 | 940 | Phase 2
Phase 2.A | CC4 | 106 | Phase 2
Phase 2.A | CC1 | 636 | Phase 2
Phase 2.A | CC2 | 95 | Phase 2
Phase 2.A | CC3 | 825 | Phase 2
Phase 2.A | CC4 | 277 | Phase 2
Phase 3.A | CC1 | 97 | Phase 3
Phase 3.A | CC2 | 693 | Phase 3
Phase 3.A | CC3 | 364 | Phase 3
Phase 3.A | CC4 | 149 | Phase 3
Phase 3.A | CC1 | 436 | Phase 3
Phase 3.A | CC2 | 354 | Phase 3
Phase 3.A | CC3 | 970 | Phase 3
Phase 3.A | CC4 | 623 | Phase 3
Phase 3.B | CC1 | 110 | Phase 3
Phase 3.B | CC2 | 178 | Phase 3
Phase 3.B | CC3 | 965 | Phase 3
Phase 3.B | CC4 | 261 | Phase 3
Phase 4.A | CC1 | 292 | Phase 4
Phase 4.A | CC2 | 337 | Phase 4
Phase 4.A | CC3 | 644 | Phase 4
Phase 4.A | CC4 | 986 | Phase 4
Phase 4.B | CC1 | 175 | Phase 4
Phase 4.B | CC2 | 536 | Phase 4
Phase 4.B | CC3 | 580 | Phase 4
Phase 4.B | CC4 | 994 | Phase 4
Phase 4.C | CC1 | 682 | Phase 4
Phase 4.C | CC2 | 697 | Phase 4
Phase 4.C | CC3 | 547 | Phase 4
Phase 4.C | CC4 | 267 | Phase 4
Phase 4.D | CC1 | 846 | Phase 4
Phase 4.D | CC2 | 639 | Phase 4
Phase 4.D | CC3 | 738 | Phase 4
Phase 4.D | CC4 | 400 | Phase 4