COGNOiSe.com - The IBM Cognos Community

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.

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.