I need to display the forecast sales based on current month said is May then i will like to display May, June, July, Aug, Sep, Oct and if more than 6 months it will rum all into final column as all. The column needs to be variable not fix, so if the current month is June, then need to display as June, July, Aug, Sep, Oct, Nov and more than 6 months will have another column to store it.
Attached is the data source and expected out that needed. I knew it must be done in Pivot but again I need variable column of six months only and more than 6 months need to display in separate column.
Anyone can helps me?
so.xls