COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: a.info on 30 Nov 2012 02:44:59 PM

Title: Calculation sum in crosstab report
Post by: a.info on 30 Nov 2012 02:44:59 PM
Hi all,
I'm sorry, my English is not good: (.

I created a crosstab in report studio with a DMR as the source (Framework Manager).
On Axis I 4 level (the highest end)
For this Axis, I want the total must equal the first level (example attached).

Thank you for your help and suggestions.
Title: Re: Calculation sum in crosstab report
Post by: MFGF on 07 Dec 2012 08:41:40 AM
Just drag in the Level 1 member again where you want the total, then change the name of the member to be "Total".

Cheers!

MF.
Title: Re: Calculation sum in crosstab report
Post by: a.info on 09 Dec 2012 02:32:07 PM
Thank you for your answer.
it works :)
Just for indicator 1, I want the total equal a val of level 1 and Indicator 2, total of all levels.

for example:

              Indicator 1    indicator 2
level 1     10                   20
level 2     11                   22
Total        10                   42


Is it possible to do?

thank you