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.