COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Analysis Studio => Topic started by: Rosanero4Ever on 04 Aug 2015 10:06:05 AM

Title: Custom sorting columns
Post by: Rosanero4Ever on 04 Aug 2015 10:06:05 AM
Hi all,

i created a simple crosstab using Analysis Studio. In columns I have some calculated measures named (for example)
"Jan-Jul 2015"
"Jan-Jul 2013"
"Jan-Jul 2014"

Analysis Studio  shows these columns using the above order.
I'd like order these measures as follows:
"Jan-Jul 2013"
"Jan-Jul 2014"
"Jan-Jul 2015"

but the order options provided are based on attribute, column name or measures values, etc..
How can I customize the order of these columns ?
I hope my explanation is clear.
Thanks very much in advance

Title: Re: Custom sorting columns
Post by: nav_shiv on 14 Sep 2015 11:02:46 AM
You could pick out these measures one at a time using the control button and then drag them into your columns.  They should appear in the order you select them from the left hand panel.