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