How to analyse next month orders

[#1]

Hi ,All

data base table consists company Id ,month wise orders.

how can i analyse  next month Orders by using last last six month data.

That mean how many orders can i except next month based on company wise

Thanks

ramu.

[#2]

Could you please explain  detail about forecasting

[pratap6699]

in your sample table contains order id with 6 months sales, if you select jan month chart display july to december sales......suppose select july  it shows jan to june sales right? then go to this expression on chart-->

sum({<month={">=$(=min(month))<=$(=min(month)-6)"}>}sales)