• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Moving average for multiple items

C

Clara

New Member
Hi,

how do I calculate weekly sales moving average for a 13 weeks period and for each Item in each warehouse.

Details are in the attached file.

Thanks
 

Attachments

  • Data.xlsx
    37.9 KB · Views: 4
Hi Clara ,

Do you want a comprehensive report , or do you want a mechanism by which you can see figures for one item at a time ?

If it is the latter , a simple pivot table and an average formula can do the job.

See the attached file.

Narayan
 

Attachments

  • Data (1).xlsx
    51.8 KB · Views: 8
Hi Narayan,
I'm looking for a comprehensive report or formula I can use. I sales numbers for each item and each warehouse once a week. I do calculate average demand for each item over last 13 weeks.

Currently I do use multiple files to calculate my average demand but I'm looking for a better way.

Thanks
Clara
 
Hi Clara ,

In which case , please specify the kind of layout you want for the output ; what will the column headers and row headers be ?

Narayan
 
You must log in or register to reply here.
Back
Top