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) 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.
Hello. I'm a full-stack developer. I have just read your requirement at carefully. I'm an exeprt of data processing by using excel VBA. I have developed many data entry projects similar with your project. Look at my po Plus
4 freelance font une offre moyenne de £85 pour ce travail
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Plus
Hello there, I have read your project description very carefully. I am excel expert. I am good at Excel formula, VBA, Macro. If you want to done your task perfectly and accurately then please contact me. Hope to hear Plus
I'll write the program using vb I'm an individual developer and my completion rate is always 100%. I STRICTLY BITE only WHICH I CAN CHEW. Message me please