Spreadsheet: 687929d1595495877-dynamic-range-linking-to-pivot-example-book
Sheet: Sheet1

Product | Sub Product | Q1 | Q2 | Q3 | Q4
Sunday | Remy Gamble | 100
Sunday | [NAME] |  |  |  |  |  |  |  |  |  | Values
Sunday | [NAME] |  |  |  |  |  |  |  | Product | Sub Product | Sum of Q1 | Sum of Q2 | Sum of Q3 | Sum of Q4 |  | Forecast
Sunday | [NAME] |  |  |  |  |  |  |  | Sunday | Ayra Macfarlane | 235 | 245 | 255 | 265
Sunday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 175 | 185 | 195 | 205
Sunday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 205 | 215 | 225 | 235
Sunday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 160 | 170 | 180 | 190
Sunday | [NAME] |  |  |  |  |  |  |  |  | Mehmet Molina | 220 | 230 | 240 | 250
Sunday | Mehmet Molina |  |  |  |  |  |  |  |  | [NAME] | 130 | 140 | 150 | 160
Sunday | Ayra Macfarlane |  |  |  |  |  |  |  |  | Remy Gamble | 100 | 110 | 120 | 130
Monday | Remy Gamble |  |  |  |  |  |  |  |  | [NAME] | 190 | 200 | 210 | 220
Monday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 145 | 155 | 165 | 175
Monday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 115 | 125 | 135 | 145
Monday | [NAME] |  |  |  |  |  |  |  | Sunday Total |  | 1675 | 1775 | 1875 | 1975 |  | 1675 | 1875 | 1925 | 1975 | [NAME]
Monday | [NAME] |  |  |  |  |  |  |  | Monday | Ayra Macfarlane | 385 | 395 | 405 | 415
Monday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 325 | 335 | 345 | 355
Monday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 355 | 365 | 375 | 385
Monday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 310 | 320 | 330 | 340
Monday | Mehmet Molina |  |  |  |  |  |  |  |  | Mehmet Molina | 370 | 380 | 390 | 400
Monday | Ayra Macfarlane |  |  |  |  |  |  |  |  | [NAME] | 280 | 290 | 300 | 310
Tuesday | Remy Gamble |  |  |  |  |  |  |  |  | Remy Gamble | 250 | 260 | 270 | 280
Tuesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 340 | 350 | 360 | 370
Tuesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 295 | 305 | 315 | 325
Tuesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 265 | 275 | 285 | 295
Tuesday | [NAME] |  |  |  |  |  |  |  | Monday Total |  | 3175 | 3275 | 3375 | 3475 |  | 3175 | 3375 | 3425 | 3475 | [NAME]
Tuesday | [NAME] |  |  |  |  |  |  |  | Tuesday | Ayra Macfarlane | 535 | 545 | 555 | 565
Tuesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 475 | 485 | 495 | 505
Tuesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 505 | 515 | 525 | 535
Tuesday | Mehmet Molina |  |  |  |  |  |  |  |  | [NAME] | 460 | 470 | 480 | 490
Tuesday | Ayra Macfarlane |  |  |  |  |  |  |  |  | Mehmet Molina | 520 | 530 | 540 | 550
Wednesday | Remy Gamble |  |  |  |  |  |  |  |  | [NAME] | 430 | 440 | 450 | 460
Wednesday | [NAME] |  |  |  |  |  |  |  |  | Remy Gamble | 400 | 410 | 420 | 430
Wednesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 490 | 500 | 510 | 520
Wednesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 445 | 455 | 465 | 475
Wednesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 415 | 425 | 435 | 445
Wednesday | [NAME] |  |  |  |  |  |  |  | Tuesday Total |  | 4675 | 4775 | 4875 | 4975 |  | 4675 | 4875 | 4925 | 4975 | [NAME]
Wednesday | [NAME] |  |  |  |  |  |  |  | Wednesday | Ayra Macfarlane | 685 | 695 | 705 | 715
Wednesday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 625 | 635 | 645 | 655
Wednesday | Mehmet Molina |  |  |  |  |  |  |  |  | [NAME] | 655 | 665 | 675 | 685
Wednesday | Ayra Macfarlane |  |  |  |  |  |  |  |  | [NAME] | 610 | 620 | 630 | 640
Thursday | Remy Gamble |  |  |  |  |  |  |  |  | Mehmet Molina | 670 | 680 | 690 | 700
Thursday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 580 | 590 | 600 | 610
Thursday | [NAME] |  |  |  |  |  |  |  |  | Remy Gamble | 550 | 560 | 570 | 580
Thursday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 640 | 650 | 660 | 670
Thursday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 595 | 605 | 615 | 625
Thursday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 565 | 575 | 585 | 595
Thursday | [NAME] |  |  |  |  |  |  |  | Wednesday Total |  | 6175 | 6275 | 6375 | 6475 |  | 6175 | 6375 | 6425 | 6475 | [NAME]
Thursday | [NAME] |  |  |  |  |  |  |  | Thursday | Ayra Macfarlane | 835 | 845 | 855 | 865
Thursday | Mehmet Molina |  |  |  |  |  |  |  |  | [NAME] | 775 | 785 | 795 | 805
Thursday | Ayra Macfarlane |  |  |  |  |  |  |  |  | [NAME] | 805 | 815 | 825 | 835
Friday | Remy Gamble |  |  |  |  |  |  |  |  | [NAME] | 760 | 770 | 780 | 790
Friday | [NAME] |  |  |  |  |  |  |  |  | Mehmet Molina | 820 | 830 | 840 | 850
Friday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 730 | 740 | 750 | 760
Friday | [NAME] |  |  |  |  |  |  |  |  | Remy Gamble | 700 | 710 | 720 | 730
Friday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 790 | 800 | 810 | 820
Friday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 745 | 755 | 765 | 775
Friday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 715 | 725 | 735 | 745
Friday | [NAME] |  |  |  |  |  |  |  | Thursday Total |  | 7675 | 7775 | 7875 | 7975 |  | 7675 | 7875 | 7925 | 7975 | [NAME]
Friday | Mehmet Molina |  |  |  |  |  |  |  | Friday | Ayra Macfarlane | 985 | 995 | 1005 | 1015
Friday | Ayra Macfarlane |  |  |  |  |  |  |  |  | [NAME] | 925 | 935 | 945 | 955
Satruday | Remy Gamble |  |  |  |  |  |  |  |  | [NAME] | 955 | 965 | 975 | 985
Satruday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 910 | 920 | 930 | 940
Satruday | [NAME] |  |  |  |  |  |  |  |  | Mehmet Molina | 970 | 980 | 990 | 1000
Satruday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 880 | 890 | 900 | 910
Satruday | [NAME] |  |  |  |  |  |  |  |  | Remy Gamble | 850 | 860 | 870 | 880
Satruday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 940 | 950 | 960 | 970
Satruday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 895 | 905 | 915 | 925
Satruday | [NAME] |  |  |  |  |  |  |  |  | [NAME] | 865 | 875 | 885 | 895
Satruday | Mehmet Molina |  |  |  |  |  |  |  | Friday Total |  | 9175 | 9275 | 9375 | 9475 |  | 9175 | 9375 | 9425 | 9475 | [NAME]
Satruday | Ayra Macfarlane |  |  |  |  |  |  |  | Satruday | Ayra Macfarlane | 1135 | 1145 | 1155 | 1165
 |  |  |  |  |  |  |  |  |  | [NAME] | 1075 | 1085 | 1095 | 1105
 |  |  |  |  |  |  |  |  |  | [NAME] | 1105 | 1115 | 1125 | 1135
 |  |  |  |  |  |  |  |  |  | [NAME] | 1060 | 1070 | 1080 | 1090
 |  |  |  |  |  |  |  |  |  | Mehmet Molina | 1120 | 1130 | 1140 | 1150
 |  |  |  |  |  |  |  |  |  | [NAME] | 1030 | 1040 | 1050 | 1060
 |  |  |  |  |  |  |  |  |  | Remy Gamble | 1000 | 1010 | 1020 | 1030
 |  |  |  |  |  |  |  |  |  | [NAME] | 1090 | 1100 | 1110 | 1120
 |  |  |  |  |  |  |  |  |  | [NAME] | 1045 | 1055 | 1065 | 1075
 |  |  |  |  |  |  |  |  |  | [NAME] | 1015 | 1025 | 1035 | 1045
 |  |  |  |  |  |  |  |  | Satruday Total |  | 10675 | 10775 | 10875 | 10975 |  | 10675 | 10875 | 10925 | 10975 | [NAME]
 |  |  |  |  |  |  |  |  | Grand Total |  | 43225 | 43925 | 44625 | 45325