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

Adding a calculated query expression as a crosstab row

Started by Rosadocc, 22 Sep 2020 12:04:57 PM

Previous topic - Next topic

Rosadocc

Hi everyone. I created a query expression [Ship Date Range] that lumps number of days into groups by using a case expression. Example below:

case
when [Ship Days]=0
then '0 Days'
when [Ship Days]<=3
then '1-3 Days'
when [Ship Days]<=7
then '4-7 Days'
end


Now I am attempting create a crosstab using the newly created [Ship Date Range] as a row showing the count of lines. Unfortunatley it doesnt seem to break it out into rows. This is what it currently looks like:



Ship Date Range 75

This is what I want it to look like:


0 Days 25
1-3 Days 25
4-7 Days 25
Total 75

What am I missing? Any help is appreciated.


Rosadocc

Nevermind, figured this one out. In case anyone else runs into this in the future:

Had to change the [Ship Date Range] Aggregate Function and Rollup Aggregate Function to "None" in the data items properties.