COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 07 Aug 2014 12:52:53 PM

Title: Crosstab Sorting
Post by: Bonediggler on 07 Aug 2014 12:52:53 PM
Experts -

I have a crosstab report that shows counts per category (rows) per year/month (columns).  How do I set the columns to sort horizontally?  I.e:

201301 201302 201303 201304 etc

Currently they are in random order.

Thank you!
Title: Re: Crosstab Sorting
Post by: karthik.kadambi on 16 Aug 2014 06:59:40 PM
You can either use the toolbar and click on the year/month data item and sort by Ascending.
Or go to the query item and change the property on the sort.