Spreadsheet: 688489d1595823483-dynamic-range-linking-to-pivot-example-upload
Sheet: Model

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast
Ignore | Ignore | Product | Ignore | Sub Product | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | 2019Q1 | 2019Q2 | 2019Q3 | 2019Q4 | 2020Q1 | 2020Q2 | 2020Q3 | 2020Q4 |  | 2021Q1 | 2021Q2 | 2021Q3 | 2021Q4
 |  | Sunday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Sunday Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1675 | 1875 | 1925 | 1975
 |  | Monday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Monday Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1675 | 1875 | 1925 | 1975
 |  | Tuesday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Tuesday Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1675 | 1875 | 1925 | 1975
 |  | Wednesday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Wednesday Total
 |  | Thursday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Thursday Total
 |  | Friday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Friday Total
 |  | Satruday |  | Ayra Macfarlane | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210
 |  |  |  | [NAME] | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
 |  |  |  | [NAME] | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230
 |  |  |  | [NAME] | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240
 |  |  |  | Mehmet Molina | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250
 |  |  |  | [NAME] | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260
 |  |  |  | Remy Gamble | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270
 |  |  |  | [NAME] | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280
 |  |  |  | [NAME] | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290
 |  |  |  | [NAME] | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300
 |  | Satruday Total
 |  | Grand Total