multi-headed cross tab structure question

[Brenj68]

Hi CR2008/ BO XI
I'm looking at creating a dual headed summarised 'x-tab' on a month by month basis, as below, calculating costs against projects. The confusion is what is the best/ more sensible approach to deliver something that has this structure manual cross tab or non-manual cross-tab. I read a thread from lbass which suggested manual approach (formuli in details, etc), but could do with a steer on whether I should go down that route

01/2011 02/2011
Forecast Actuals Forecast Actuals
£ £ £ £

Project name xxx
Project name yyy
Project name aaa
Project name bbb
Project name ccc
Project name ddd
Project name eee

Yours confused of W5

 

[IanWaterman]

If you can build a single formula which will out put forecast or actual figures then use a standard cross tab. As this is unlikely you will probably need to use a manual cross tab.

Ian

 

[lbass]

If this is all there is to it, you should just insert a crosstab, use project name as the row field, and date as your first column (go to group options->select on change of month). I'm unclear on what "forecast actuals" is--is this the summary field? If not, then add it as your second column and add sum of costs as your summary field.

-LB