Hey guys,
Need some help. I'm trying to create an end of the month projection for some sales data.
For example,I have some sales data for each day for multiple products in a table. I also have a column called monthly projection that I would like to be populated with an end of month projection based on the running average up until that day for each product.
Take a look at the sheet attached for more details.
Thanks guys
Bookmarks