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

Sorting on a particular column in crosstab

Started by coolbaba, 28 Jan 2008 04:00:35 PM

Previous topic - Next topic

coolbaba

Hello All,
I have a requirement where I bring in person details as rows and year (level-1)& month(level-2) as the columns and amount spent as the measure in the crosstab. My requirement is to show the year and months in the descending order meaning from latest data to oldest... 2007-dec to 2007-nov...2006-dec.
The hard part is to sort the measure in desc order for the latest year and month. i.e., for only 2007-dec I need to sort the measure value in desc order. How do I sort on this particular dynamic value in column?
Regards,
S