CROSSTAB - How to create a Total lign

[tamise]

Hello,

I am using report studio in order to make crosstab. But I have no idea how to create a Total lign.
Can you please give me some ideas ?

Thanks for your help !!

[MFGF]

Hi,

Are you using a relational or dimensional package?

One option is to select your row (or column) headings and use the Aggregate button on the toolbar (Ʃ)

Regards,

MF.

[tamise]

I use the relational package in the framework

[MFGF]

ok. As above, then. Use the Aggregate button on the toolbar.

Alternatively, add a query calculation below the rows (or to the right of the columns) with the expression

total([measure])

MF.

[tamise]

So tried to put total(measure) on the query but it shows a message error

[MFGF]

So tried to put total(measure) on the query but it shows a message error

I'm afraid I left my clairvoyance tiara on a bus, so I can't figure out what the error message you got was telling you. Perhaps you could post it up?