Skip to Content
0
Former Member
Sep 03, 2008 at 05:04 AM

Query Output Format

58 Views

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.