Spreadsheet: 80482d1280738684-adding-range-of-data-top10_rev1
Sheet: Sheet1

Week | Product | Qty | Value |  |  |  |  | Data
Week 1 | Product 1 | 88 | 233 |  |  | Product | Week | Sum of Qty | Sum of Value |  | Dynamic Named Range Pivot_Range for Pivot Table Data Source =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),4)
Week 1 | Product 2 | 66 | 133 |  |  | Product 6 | Week 1 | 71 | 733 |  | Right click on Product - Select Field Settings - Advanced:
Week 1 | Product 3 | 66 | 413 |  |  |  | Week 2 | 73 | 635 |  | AutoSort Descending using field Sum of Value
Week 1 | Product 4 | 100 | 854 |  |  |  | Week 3 | 48 | 838 |  | Top 10 AutoShow On using field Sum of Value
Week 1 | Product 5 | 42 | 572 |  |  |  | Week 4 | 48 | 838 |  | Refresh the Pivot Table if the Data Source is added to or if any values change
Week 1 | Product 6 | 71 | 733 |  |  | Product 6 Total |  | 240 | 3044 |  | Right click on Product - Group and Show Detail to show or hide Week detail
Week 1 | Product 7 | 65 | 148 |  |  | Product 9 | Week 1 | 44 | 638
Week 1 | Product 8 | 13 | 437 |  |  |  | Week 2 | 28 | 122
Week 1 | Product 9 | 44 | 638 |  |  |  | Week 3 | 15 | 965
Week 1 | Product 10 | 84 | 330 |  |  |  | Week 4 | 15 | 965
Week 2 | Product 1 | 79 | 924 |  |  | Product 9 Total |  | 102 | 2690
Week 2 | Product 2 | 28 | 507 |  |  | Product 5 | Week 1 | 42 | 572
Week 2 | Product 3 | 93 | 734 |  |  |  | Week 2 | 24 | 951
Week 2 | Product 4 | 57 | 526 |  |  |  | Week 3 | 77 | 930
Week 2 | Product 5 | 24 | 951 |  |  | Product 5 Total |  | 143 | 2453
Week 2 | Product 6 | 73 | 635 |  |  | Product 10 | Week 1 | 84 | 330
Week 2 | Product 7 | 48 | 484 |  |  |  | Week 2 | 13 | 221
Week 2 | Product 8 | 40 | 764 |  |  |  | Week 3 | 26 | 904
Week 2 | Product 9 | 28 | 122 |  |  |  | Week 4 | 26 | 904
Week 2 | Product 10 | 13 | 221 |  |  | Product 10 Total |  | 149 | 2359
Week 3 | Product 1 | 59 | 860 |  |  | Product 8 | Week 1 | 13 | 437
Week 3 | Product 2 | 49 | 1000 |  |  |  | Week 2 | 40 | 764
Week 3 | Product 5 | 77 | 930 |  |  |  | Week 3 | 47 | 564
Week 3 | Product 6 | 48 | 838 |  |  |  | Week 4 | 47 | 564
Week 3 | Product 7 | 41 | 748 |  |  | Product 8 Total |  | 147 | 2329
Week 3 | Product 8 | 47 | 564 |  |  | Product 7 | Week 1 | 65 | 148
Week 3 | Product 9 | 15 | 965 |  |  |  | Week 2 | 48 | 484
Week 3 | Product 10 | 26 | 904 |  |  |  | Week 3 | 41 | 748
Week 3 | Product 11 | 37 | 843 |  |  |  | Week 4 | 41 | 748
Week 3 | Product 12 | 48 | 782 |  |  | Product 7 Total |  | 195 | 2128
Week 3 | Product 13 | 59 | 721 |  |  | Product 1 | Week 1 | 88 | 233
Week 3 | Product 14 | 70 | 660 |  |  |  | Week 2 | 79 | 924
Week 3 | Product 15 | 81 | 599 |  |  |  | Week 3 | 59 | 860
Week 3 | Product 16 | 92 | 538 |  |  | Product 1 Total |  | 226 | 2017
Week 3 | Product 17 | 103 | 477 |  |  | Product 11 | Week 3 | 37 | 843
Week 3 | Product 18 | 114 | 416 |  |  |  | Week 4 | 37 | 843
Week 3 | Product 19 | 125 | 355 |  |  | Product 11 Total |  | 74 | 1686
Week 3 | Product 20 | 136 | 294 |  |  | Product 2 | Week 1 | 66 | 133
Week 4 | Product 6 | 48 | 838 |  |  |  | Week 2 | 28 | 507
Week 4 | Product 7 | 41 | 748 |  |  |  | Week 3 | 49 | 1000
Week 4 | Product 8 | 47 | 564 |  |  | Product 2 Total |  | 143 | 1640
Week 4 | Product 9 | 15 | 965 |  |  | Product 12 | Week 3 | 48 | 782
Week 4 | Product 10 | 26 | 904 |  |  |  | Week 4 | 48 | 782
Week 4 | Product 11 | 37 | 843 |  |  | Product 12 Total |  | 96 | 1564
Week 4 | Product 12 | 48 | 782 |  |  | Grand Total |  | 1515 | 21910
Week 4 | Product 13 | 59 | 721
Week 4 | Product 14 | 70 | 660
Week 4 | Product 15 | 81 | 599
Week 4 | Product 16 | 92 | 538
Week 4 | Product 17 | 103 | 477
Week 4 | Product 18 | 114 | 416
Week 4 | Product 19 | 125 | 355
Week 4 | Product 20 | 136 | 294