Excel Pivot Average Monthly Unit Sales Per Quarter DAX Predict VB


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.

Many Thanks.

Kemahiran: Excel, Visual Basic, Pemprosesan Data, Visual Basic untuk Aplikasi, Excel Macros

Lihat lagi: average 100 unique hits per day, sales per month, average data entering speed per minute, average monthly sales web design services, excel chart compare monthly sales total sales, pivot table average monthly sales, monthly individual sales excel sheet, pivot table monthly sales, average sales per day telemarketing, average sales per day spreadsheet, average sales per day typical telemarketer, average sales per month clickbank, unit sales tracking reports excel, monthly inventory sales excel, daily weekly monthly inventory sales excel, starting base cuboid list average monthly sales product, WITH ABSENCE RATE COST PER HIRE HR EXPENSE FACTOR TIME TO FILL DAYS AND TURNOVER RATE

Tentang Majikan:
( 0 ulasan ) Stourbridge, United Kingdom

ID Projek: #20761601

Dianugerahkan kepada:


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 Lagi

£150 GBP dalam 3 hari
(0 Ulasan)

4 pekerja bebas membida secara purata £85 untuk pekerjaan ini


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 Lagi

£20 GBP dalam sehari
(14 Ulasan)

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 Lagi

£20 GBP dalam sehari
(9 Ulasan)

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

£150 GBP dalam 5 hari
(0 Ulasan)