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

crosstab summary for OLAP source

Started by venkiatmaruthi, 07 Dec 2011 03:05:10 AM

Previous topic - Next topic

venkiatmaruthi

Hi,

I have Transformer Cube as package.
Using this I created a crosstab where it has fact cell [count] that we make it as percent using Data Format. it has a Row as [Rep name] and column as [inspection].

the report is working fine. Now I need to add summary filed where it should give total percent of those [rep_name]

Here the problem is suppose cross tab is showing 4 rows showing count percent 40%, 60%, 35%, 25%. when I added summary as average or aggregate it is not showing 40% [Total cout percent(40+60+35+25)/4 (no of rows)] rather its showing 25% or 30%.

I found the reason that some of the rows giving 0% and in cross tab properites they mentioned supress zero values in Data section.

I want now this suppress also to applied to summary also. please advise.

venkiatmaruthi

Looks simple but finding it and making it working takes time :)
I unchecked zero values in suppress property of crosstab.
I kept filter in detail filter. Now its working fine.