COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: gatorfe on 16 Mar 2010 03:20:54 PM

Title: Exclude Column
Post by: gatorfe on 16 Mar 2010 03:20:54 PM
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!
Title: Re: Exclude Column
Post by: redmist on 16 Mar 2010 05:21:06 PM
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.