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

Applying SortKey on a Crosstab Section

Started by RL_Boston, 24 Apr 2013 10:19:54 AM

Previous topic - Next topic

RL_Boston

Hi All -

Basically, I have two queries, that Join on a Data Item (Products). In the Joined Query I have another Data Item that has a Case Statement which groups the results into a "Product Category". I then created a Section based on this Product Category but would like them to be sorted in a specific order. Therefore I created a SortKey  and applied it to the Section, but I get an aggregate error.

Does anyone know if a SortKey on a Section is allowed in Cognos? 


Thanks in advance!