Concluído

Project for Ejiwole O.

Hi,

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.

Many Thanks.

Habilidades: Processamento de dados, Excel, Excel Macros, Visual Basic, Visual Basic para Apps

Veja mais: add project job number email outlook, add images asp project, add fla file project flash, sugarcrm add project calendar, continuation previous project, posting add wanted employees, wanted project manager web denver, wanted captcha data entry project, wanted captcha data entry project bangladesh, add live chat project, add radio buttons project, web project partners wanted, webdesigner wanted project, webdesigner wanted open source project, add wordpress blog aspnet project, game project artist wanted, add feed module project java, add shopping cart website average cost, Hi Guys, I need a square banner for promotion in facebook and instagram, The banner has to have a very good fonts, please be c, The project and fairly new, but it is related to the animal world, dog and cat.

Acerca do Empregador:
( 0 comentários ) Stourbridge, United Kingdom

ID do Projeto: #20784211

Concedido a:

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 Mais

£20 GBP em 1 dia
(14 Comentários)
4.8

2 freelancers estão ofertando em média £78 para esse trabalho

jinjinwu

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.

£135 GBP in 5 dias
(0 Comentários)
0.0