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

Cognos 11 Crosstab multiple time periods

Started by zgeorge, 20 Nov 2018 02:13:57 PM

Previous topic - Next topic

zgeorge

I have a requirement to create a crosstab that have several rows from different hierarchy and several columns. One of the requirements is to allow for the user to select from YTD and MTD time periods. I've been able to accomplish this and my values are adjusting as expected.

The next requirement is to have the bottom section of the report to ignore that time period prompt and only have it render for YTD, even if the time period prompt changes to MTD.

It's also worth noting that in my crosstab columns, I have a conditional data item that will pick either the YTD data item or the MTD data item.

Is there anyway I can tell a row from my crosstab to ignore the column data item and only use the YTD data item?