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

Group By and Order By in table

Started by kennedto, 09 Mar 2017 09:28:27 AM

Previous topic - Next topic

kennedto

I am using cognos 10.2.

I have the following table:

MonthNum   MonthName Owner TaskCount

MonthNum is hidden.
I would like to order the table by MonthNum and group it by MonthName.

If I try to sort  and group at the same time, the Monthname is not sorted.
If I ungroup Monthname, then the sort works properly.
The Aggregate and Rollup Aggregate functions are all set to Non for all columns.

What am I doing wrong here?


BigChris

I think you probably need to set the detail sorting in the "Sorting and Grouping" from the Properties pane.

kennedto