As discussed his is a project for - Ejiwole O
This is under the explicit priviso that the work is completed by 12:00 GMT UK Time on 12/08/2018 as this is a time critical project as discussed via chat,
I have created a pivot table in Excel which shows historic unit sales by Year/Quarter/Month see screenshot.
I am trying to predict based on previous years quarter unit sales how much I need for this year.
I wanted to add a measure in DAX to calculate the average Monthly unit sales by quarter to include in the pivot table.
And then on a seperate sheet show how many units we would need per SKU this year for a Quarter (configurable) via dropdown based on last years unit sales.
To forward plan what we should be buying,
I don't mind how this is done whether this needs to be VB as long as it it is customisable.
2 freelancers estão ofertando em média £78 para esse trabalho
Hi, client. I saw your posting with interesting. I have experience with your request skills. So I think I can solve your project asap I will wait for your response. Kindly regards.