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

three dataitems that has % values

Started by cognos05, 11 Aug 2020 02:06:26 PM

Previous topic - Next topic

cognos05

Hi ,

I have a olap cube and building a report .

That uses these calculation

AgroupItems - set of items based on certain condition
BgroupItems - set of items based on certain condition
CGroupItems -set of items based on certain condition
ConsignedItems - set of items based on certain condition

I am doing 4 counts
Count(1 within set [Consigned Items])
Count(1 within set [AgroupItems])
Count(1 within set [BgroupItems])
Count(1 within set [CgroupItems])


Then A% is Count(1 within set [AgroupItems])/Count(1 within set [Consigned Items])
Then B% is Count(1 within set [BgroupItems])/Count(1 within set [Consigned Items])
Then C% is Count(1 within set [CgroupItems])/Count(1 within set [Consigned Items])

so this three data items shows properly in crosstab , but then when i put the data items in a stacked column or column chart , I dont see any values.

Any suggestions on how to trouble shoot is appreciated.

Here my A.B .C are individual percent counts, trying to put in old column chart .

Thanks,