report on sales pattren
I need to design a report the requirement is
MATERIAL1 business is increased by 20% in a quarter
how would be the sales in the next quarter
how to design this report
thanks in advance
Gordon Du replied
If I understand you correctly, you need a report to show sales trend.
This is not a difficult report. You can do it by an XL Report, a query or by any other report tools.
Since you can get current quarter actual sales data easily, you just need to put a formula against the actual data as:
next quarter = current quarter x 1.2.
If you only need show next quarter data, hide your current.