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

Crosstab Sorting Issues

Started by pammassey, 06 Sep 2017 08:55:01 AM

Previous topic - Next topic

pammassey

I have created a crosstab report where the column headers are months spanning a year sorted descending.  The quantity that appears beneath those columns are the correct quantities but they're not aligning under the correct months.  Any ideas on how to address this issue?

pammassey

The crosstab spaces I used to create column headers for the crosstab is creating the issue.  When they're not there, the numbers appear under the right months.

New_Guy

Hi,
Column headers can be created using tables and blocks in the crosstab nodes itself by unlocking the nodes. Check the pad lock icon on the tool bar. If you have to use the crosstab spaces then you have to do the boxtype none to the actual month nodes and the crosstab space fact cells has to be boxtype none too.
Good luck
New guy