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

Exclude Column

Started by gatorfe, 16 Mar 2010 03:20:54 PM

Previous topic - Next topic

gatorfe

I have an analysis report that shows sales and orders for each month in 2010(columns) by product code(rows).  For the months of Jan and Feb I dont want to see the orders column just the sales column.  Is there a way to exclude a column from speficic time periods?  The way it works for me now is that if I exclude sales it excludes it from all months.  Thanks in advance for your help/suggestions!

redmist

The way i would do it is first put only Jan in the columns. Now stack the nest of the months next to Jan. This way you can have different sets of measures for Jan and rest of the months.