Delgado_helps
Banned user
- Joined
- Aug 5, 2022
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
My ask is
Please use the attached excel file as your total event sales forecast for Q3 and Q4. The ask is simply to break these forecasts out into Northern, Southern, Western. Feel free to set up the data/table however you feel makes sense, whether in a data set that we can pivot or table
So i broke them them down in sheet 2
I need help with what formula i can use here
To find the FY21 Divisional sales allocations use the dashboard link below and simply sort on Division. You should be able to take the “individual Division total / the company total” to get a sales allocation by Division
On sheet 3 is the sales so i can get a formula to use on sheet 2. Any help?
Please use the attached excel file as your total event sales forecast for Q3 and Q4. The ask is simply to break these forecasts out into Northern, Southern, Western. Feel free to set up the data/table however you feel makes sense, whether in a data set that we can pivot or table
So i broke them them down in sheet 2
I need help with what formula i can use here
To find the FY21 Divisional sales allocations use the dashboard link below and simply sort on Division. You should be able to take the “individual Division total / the company total” to get a sales allocation by Division
On sheet 3 is the sales so i can get a formula to use on sheet 2. Any help?