Terminé

Excel Pivot Average Monthly Unit Sales Per Quarter DAX Predict VB

Hi,

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.

Compétences : Excel, Visual Basic, Traitement de Données, Visual Basic pour les apps , Excel Macros

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Stourbridge, United Kingdom

Nº du projet : #20761601

Décerné à:

finest2019

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 3 jours
(0 Commentaires)
0.0

4 freelance font une offre moyenne de £85 pour ce travail

olaideejiwole

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(14 Commentaires)
4.8
Rasel2543

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(9 Commentaires)
3.2
redtee

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0