Spreadsheet: 690030d1596810493-help-with-forecasting-formula-for-a-retailer-i-am-stumped-please-help-phasing-help-answer
Sheet: Dashboard example

Key Forecast | Cateogry | Type | Group | Gender | Start week* | RID MERCH | [NAME] | 8/3/20 | 8/10/20 | 8/17/20 | 8/24/20 | 8/31/20 | 9/7/20 | 9/14/20 | 9/21/20 | 9/28/20 | 10/5/20 | 10/12/20 | 10/19/20 | 10/26/20 | 11/2/20 | 11/9/20 | 11/16/20 | 11/23/20 | 11/30/20 | 12/7/20 | 12/14/20 | 12/21/20 | 1/4/21 | 1/11/21 | 1/18/21 | 1/25/21 | 2/1/21
 | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300
 | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154
 |  |  |  |  |  |  |  |  |  |  |  |  | Change the Key Forcast Filter to the Product you want
 |  |  |  |  |  |  |  |  |  |  |  |  | Read equation of linear trendline to make prediction.
 |  |  |  |  |  |  |  |  |  |  | Key Forecast | FootwearENDURSHOESU
Key Forecast | Cateogry | Type | Group | Gender | Start week* | RID MERCH | [NAME] | WeekDate | Value
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 8/3/20 | 82 |  | Row Labels | Sum of Value
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 8/10/20 | 67 |  | 1/11/21 | 30
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 8/17/20 | 67 |  | 1/18/21 | 30
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 8/24/20 | 65 |  | 1/25/21 | 28
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 8/31/20 | 72 |  | 1/4/21 | 32
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 9/7/20 | 72 |  | 10/12/20 | 82
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 9/14/20 | 84 |  | 10/19/20 | 86
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 9/21/20 | 44 |  | 10/26/20 | 42
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 9/28/20 | 58 |  | 10/5/20 | 57
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 10/5/20 | 57 |  | 11/16/20 | 30
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 10/12/20 | 82 |  | 11/2/20 | 34
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 10/19/20 | 86 |  | 11/23/20 | 37
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 10/26/20 | 42 |  | 11/30/20 | 37
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 11/2/20 | 34 |  | 11/9/20 | 31
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 11/9/20 | 31 |  | 12/14/20 | 42
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 11/16/20 | 30 |  | 12/21/20 | 26
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 11/23/20 | 37 |  | 12/7/20 | 37
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 11/30/20 | 37 |  | 2/1/21 | 30
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 12/7/20 | 37 |  | 8/10/20 | 67
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 12/14/20 | 42 |  | 8/17/20 | 67
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 12/21/20 | 26 |  | 8/24/20 | 65
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 1/4/21 | 32 |  | 8/3/20 | 82
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 1/11/21 | 30 |  | 8/31/20 | 72
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 1/18/21 | 30 |  | 9/14/20 | 84
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 1/25/21 | 28 |  | 9/21/20 | 44
FootwearENDURSHOESU | Footwear | ENDUR | SHOES | U | 2020-09-14 00:00:00 | 2020-09-01 00:00:00 | 1300 | 2/1/21 | 30 |  | 9/28/20 | 58
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 8/3/20 | 16 |  | 9/7/20 | 72
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 8/10/20 | 4 |  | Grand Total | 1302
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 8/17/20 | 3
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 8/24/20 | 0
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 8/31/20 | 2
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 9/7/20 | 3
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 9/14/20 | 2
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 9/21/20 | 4
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 9/28/20 | 10
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 10/5/20 | 9
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 10/12/20 | 25
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 10/19/20 | 27
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 10/26/20 | 38
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 11/2/20 | 34
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 11/9/20 | 36
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 11/16/20 | 48
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 11/23/20 | 106
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 11/30/20 | 72
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 12/7/20 | 115
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 12/14/20 | 117
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 12/21/20 | 134
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 1/4/21 | 110
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 1/11/21 | 99
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 1/18/21 | 52
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 1/25/21 | 45
SocksRunning SocksSOCKSU | Socks | Running Socks | SOCKS | U | 2020-10-05 00:00:00 | 2020-07-15 00:00:00 | 1154 | 2/1/21 | 43