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

Report Month AND Month YTD when User selects Month

Started by Iggy, 24 Jul 2011 02:24:41 PM

Previous topic - Next topic

Iggy

Hello COGNOS community,

I am just getting started with Report Studio and have the following problem;

My Report source is TM1 and I am creating a crosstab report using report studio.

The problem I am having is that we have one dimension for [Month] this has elements for each month and consolidations for each month YTD (Year to Date).

I want the user to be prompted for the Month,  but somehow return columns in the crosstab for both Month and Month YTD.  Is there some way I can add the prompted month with |' YTD' to have this reported also? (like I would have done when reporting in Excel?)

It someone can can give me some pointers here I would be much appreciated.