Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: tamise on 27 Oct 2013 04:23:29 AM

Title: CROSSTAB - How to create a Total lign
Post by: tamise on 27 Oct 2013 04:23:29 AM
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 !!
Title: Re: CROSSTAB - How to create a Total lign
Post by: MFGF on 27 Oct 2013 10:24:32 AM
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.
Title: Re: CROSSTAB - How to create a Total lign
Post by: tamise on 27 Oct 2013 01:38:28 PM
I use the relational package in the framework
Title: Re: CROSSTAB - How to create a Total lign
Post by: MFGF on 27 Oct 2013 01:59:33 PM
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.
Title: Re: CROSSTAB - How to create a Total lign
Post by: tamise on 28 Oct 2013 02:49:59 PM
So tried to put total(measure) on the query but it shows a message error
Title: Re: CROSSTAB - How to create a Total lign
Post by: MFGF on 28 Oct 2013 03:11:24 PM
Quote from: tamise on 28 Oct 2013 02:49:59 PM
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?
Text only | Text with Images