Please help me prepare "Sale by Customer By Channel report "as attached format.
Then, this will be distribute to the sales team to review each salesman projection,participation projects to summarize all the focus areas in order to meet our sales target.
The row of "Sales + Backlog "= Actual sale Jan-Apr, from Jun onward will be the backlog by month.
The row of "Anticipation project "= This will be fulfil by each sale staffs
- Each sales staff can start to prepare this row
- Please put the value in the delivery month column and name the project by add comment function