CrossTab design issue

[mrcool]

Hi All,

Could you please throw some ideas to achieve following requirement:
I have 3 nested measues as rows and band in columns.it's easy part till here..Now the problem is I have to show
forecast measure in column next to total. This is where I am completly struck. Any help would be highly appreciated.

Attached sample report.

   

[mrcool]

Any thoughts please?

[BigChris]

Assuming you've got the forecast measure, just drag it into you crosstab to the right of the total column.

[RKMI]

Mr. Cool,

Is this of a Cube, DMR or relational. If its a cube you should be able to pull the member and add it in the crosstab as Chris suggested.

(Or) another apporach I would take is create a new dimension actual and forecast nest the bands in the acutals and forecast as in the column.

But, if its realational you might need to dummy up a query join on a key/ sort item(1). And your output query will have the band the three measures and a sort item(2) then use the sort item to show before or after the band.

Thanks,
RK

[mrcool]

Thank you all for your response.
@BigChris.. That doesn't work as I have few measures in rows and 1 in columns.

@RKMI- Iam using relational datasource. If you don't mind could you please send me a sample report in xml.

Thanks,
MC

[RandomHunter]

What you could do, is make a crosstab next to your initial crosstab with the same data items in the rows and the forecast as the column. Then you just hide the rows and normally both crosstabs should look like one crosstab. It's not an ideal solution, but it should work.

BR,

Hunter

[mrcool]

Thank you so much Randomhunter..I will try it..