Gurus,
Need your advice on how to achieve the following output on the Query:
................................Period 1..........Period 2.........Period 3
...............................Plan : Actual...Plan : Actual...Plan : Actual
Cost Center 115960...100....90........120.....130..........150.....160
Basically the report will show the Plan and Actual cost posted to the particular cost centre. We have total 12 Period (12 months), so 12 column on the output. Under each Period, I would like to sub-divide into 2 column u2013 for Plan and Actual cost.
Is this doable?
Please advice, thanks.