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: test

 |  |  |  |  |  |  |  |  |  | Intended outcome of summary with 'dynamic' summary area |  |  |  |  |  |  | Outcome with automatically updated area for summary
 |  |  |  |  | SUM
 |  |  |  |  |  |  |  |  |  | Title: Phase 1 details |  |  |  |  |  |  | Title: Phase 1 details
 |  |  |  |  |  |  |  |  |  | Phase | CC1 sum | CC2 sum | CC3 sum | CC4 sum |  |  | Phase | CC1 sum | CC2 sum | CC3 sum | CC4 sum
 |  |  |  | Phase 1.B |  |  |  |  |  | Filter all unique Phases 1.x here, if more rows needed, "auto expand the green area/add more rows" |  |  |  |  |  |  | As additional row would be needed, the area would be automatically extended
 |  |  |  | Phase 1.C |  |  |  |  |  | As based on current data, Phase 1 would require 3 rows, instead of predefined area of 3 rows
 |  |  |  | Phase 1.D
 |  |  |  | Phase 1.E
 |  |  |  | Phase 2.A |  |  |  |  |  | Title: Phase 2 details
 |  |  |  | Phase 2.B |  |  |  |  |  | Phase | CC1 sum | CC2 sum | CC3 sum | CC4 sum
 |  |  |  | Phase 3.A |  |  |  |  |  | Filter all unique Phases 2.x here, if more rows needed, "auto expand the yellow area/add more rows" |  |  |  |  |  |  | Title: Phase 2 details
 |  |  |  | Phase 3.B |  |  |  |  |  | As based on current data, Phase 2 would require only 2 rows, instead of predefined area of 3 rows |  |  |  |  |  |  | Phase | CC1 sum | CC2 sum | CC3 sum | CC4 sum
 |  |  |  | Phase 4.A |  |  |  |  |  |  |  |  |  |  |  |  | Only two rows needed - "auto shrink" area
 |  |  |  | Phase 4.B
 |  |  |  | Phase 4.C
 |  |  |  | Phase 4.D
 |  |  |  | PHASES | CC1 | CC2 | CC3 | CC4
 | Phase 1.A |  |  | Phase 1.A | 121 | 45 | 789 | 68 |  | Pha
 | Phase 1.B |  |  | Phase 1.B | 572 | 798 | 9 | 51 |  | opt
 | Phase 1.C |  |  | Phase 1.C | 691 | 295 | 151 | 799
 | Phase 1.D |  |  | Phase 1.D | 339 | 510 | 33 | 56
 | Phase 1.E |  |  | Phase 1.E | 808 | 196 | 418 | 500
 | Phase 2.A |  |  |  | 361 | 523 | 630 | 893
 | Phase 2.B |  |  | Phase 2.A | 425 | 129 | 915 | 130
 | Phase 2.C |  |  | Phase 2.A | 640 | 202 | 776 | 83
 | Phase 2.D |  |  | Phase 2.B | 184 | 23 | 973 | 510
 | Phase 3.A |  |  | Phase 2.B | 523 | 246 | 295 | 974
 | Phase 3.B |  |  | Phase 2.A | 881 | 702 | 940 | 106
 | Phase 3.C |  |  | Phase 2.A | 636 | 95 | 825 | 277
 | Phase 3.D |  |  |  | 55 | 234 | 626 | 976
 | Phase 4.A |  |  | Phase 3.A | 97 | 693 | 364 | 149
 | Phase 4.B |  |  | Phase 3.A | 436 | 354 | 970 | 623
 | Phase 4.C |  |  | Phase 3.B | 110 | 178 | 965 | 261
 | Phase 4.D |  |  |  | 524 | 8 | 158 | 342
 | Phase 5.A |  |  |  | 201 | 691 | 756 | 333
 | Phase 5.B |  |  |  | 424 | 312 | 976 | 249
 | Phase 5.C |  |  | Phase 4.A | 292 | 337 | 644 | 986
 | Phase 5.D |  |  | Phase 4.B | 175 | 536 | 580 | 994
 | Phase 6.A |  |  | Phase 4.C | 682 | 697 | 547 | 267
 | Phase 6.B |  |  | Phase 4.D | 846 | 639 | 738 | 400
 | Phase 6.C |  |  |  | 799 | 847 | 631 | 639
 | Phase 6.D |  |  |  | 857 | 118 | 397 | 30
 | Phase 7.A |  |  |  | 736 | 527 | 581 | 233
 | Phase 7.B |  |  |  | 196 | 182 | 997 | 178
 | Phase 7.C |  |  |  | 155 | 970 | 695 | 908
 | Phase 7.D |  |  |  | 297 | 518 | 579 | 250
 |  |  |  |  | 119 | 104 | 437 | 70
 |  |  |  |  | 812 | 634 | 440 | 711
 |  |  |  |  | 21 | 96 | 197 | 749
 |  |  |  |  | 862 | 713 | 627 | 687
 |  |  |  |  | 899 | 875 | 217 | 806