Print Page - Sorting Data

Title: Sorting Data
Post by: vsudaya on 18 Jan 2006 02:53:06 AM

Hi all,

How we can do primary,secondary sorting in a list. eg: i want date to be sorty be descending first, then by name in asc. how can we achieve in a list object.?

Thanks in advance
vsud

Title: Re: Sorting Data
Post by: BIsrik on 18 Jan 2006 06:20:00 AM

The sort hierarchy of the columns is determined by the order that the columns are placed in the tabular model.
In the tabular model, place the date field first and then the name. apply ur sorting and check it out..

Srik

Title: Re: Sorting Data
Post by: vsudaya on 18 Jan 2006 06:36:32 AM

Hi srik,

thanks, but if i change it in the tabular model-query-facts only it is working. if i change the order in tabular it is not working.

vsud

Title: Re: Sorting Data
Post by: CoginAustin on 18 Jan 2006 01:19:41 PM

Go to your query and drag your Name under your data dimension and under your date field. Then set the sort order for both?

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: vsudaya on 18 Jan 2006 02:53:06 AM