Forum Discussion
dominique2001gh
May 02, 2022Copper Contributor
Demand Forecasting Using Pivot Table
Hello , I am trying to forecast demand for a material product. my data is a year data starting from April 2021 to April 2022. However some of the weeks have zero transactions. so anytime I try to do...
OliverScheurich
May 02, 2022Gold Contributor
- dominique2001ghMay 02, 2022Copper ContributorI mean it the formula you gave me returned zero
- OliverScheurichMay 02, 2022Gold Contributor
Does it work in the attached file?
- dominique2001ghMay 02, 2022Copper Contributordoesnt work either
- dominique2001ghMay 02, 2022Copper ContributorHello Pawn,
Thank you for your prompt response. I appreciate you.
I tried your formula but it gives me zero