COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: koolbachi on 06 Aug 2007 03:33:05 PM

Title: Sorting in Crosstab report
Post by: koolbachi on 06 Aug 2007 03:33:05 PM
Hi,

I have a crosstab report, which looks like

                                   Year_Week No                            Year_Week No
                            Cal1          Cal2                         Cal1                   Cal2
Factory desc   Estimate   <#1234#>   <#1234#>     <#1234#>   <#1234#>
Factory desc   Estimate   <#1234#>   <#1234#>   <#1234#>   <#1234#>


I want to sort the output based on the Cal2 for latest  latest Year_week No .

please find the attachment.

How is it possible.

Thanks in Advance

Gops
Title: Re: Sorting in Crosstab report
Post by: naveen_hadagali on 06 Aug 2007 10:29:57 PM
Hi,

Select year and then on the top of the screen u have advanced sorting option ..there you can set the sorting for call2 and the year as descending .....hope this helps.

Regards
Naveen
Title: Re: Sorting in Crosstab report
Post by: koolbachi on 07 Aug 2007 01:39:15 AM
Hi Naveen,

I had tried that already it doesn't work for me.

I had sorted the year in descending and i want to show the data for the latest year in descending based on Cal2.

Thanks in advance

Gops
Title: Re: Sorting in Crosstab report
Post by: naveen_hadagali on 07 Aug 2007 02:43:01 AM
use the max function in date and try...so that it will take only the latest date.....
Title: Re: Sorting in Crosstab report
Post by: rockytopmark on 10 Aug 2007 10:59:12 AM
Sorting in a Crosstab with Cube or DMR source can be done using the Order() function. 

Further, sorting while displaying only a Top n number of records can be done with the TopCount() function.