Forum Discussion
Anonymous
7 years agoNot applicable
Forecast
Hi All, I need advise on the below scenario, wish to present the Forecast weekly. In my organization i present the weekly summary by comparing the current file with previous week file. filnd the...
v-yulgu-msft
Microsoft Employee
7 years agoHi Anonymous,
It would be better you could illustrate the scenario with sample data and desired putput.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
- Anonymous7 years agoNot applicable
Hi Yuliana Gu,
Thanks for your response. Please find the proces which i does
- I need to present forecast report weekly with the support of 3 individual reports.
- Say I have R1, R2, R3 reports, every week I shall get a latest file includes new clients added and change in revenue for the existing client list and need to present the changes based on client (present all the client list according to latest repot i.e change in revenue for existing client Revenue and new client revenue additions based on month)
- Every report has Client name month and Revenue furcated (Expected).
- Client is the common field among all the fields.
- Finally, shall summarize all the deference from individual report and present in one view and this revenue change will impact on the forecasting FY Revenue.
Please let me know if you need forther information.
REgards,
Varun