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 problem

Started by cognosryanc, 26 Jun 2019 11:46:16 AM

Previous topic - Next topic

cognosryanc

Hi everyone,

I'm creating a proof of concept from a sql node. Im trying to create a cross tab with the week numbers across the columns and the then the calls handled percentage and the max call length. sounds simple but when i add in the max call length it displays it in the rows instead of underneath (see attached pictures). Ive tried to do a number of different changes to the maxiumum calculation but to no avail. Any ideas guys im tearing my hair out here :)

BTW im using Cognos Analytics 11.1 R2.

Thanks Ryan

hellokimy310

Can you try to unlock the crosstab, add a measure then click on the measure and in the crosstab intersection property set the "define contents" to YES.  Then you should be able to drag the percentage calculation into the measures. 

hellokimy310

Also, if it's a measure, you may also want to try to change the "Data item value" to Cell Value when you unlock the crosstab and change the define contents --> YES.