If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calculation sum in crosstab report

Started by a.info, 30 Nov 2012 02:44:59 PM

Previous topic - Next topic

a.info

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.

MFGF

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.
Meep!

a.info

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