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.