How to change the heading in crosstab node member

[pravin.cognos]

Dear Gurus

I have created a Cross tab report and have totaled the columns. I need to change the heading of the Crosstab Node member from "Total(PY)" to year, which will be dynamically selected by the user in the prompt page. I tried Unlocking, Pulling a text item into the Heading of the column and changing the Text source Type as Data Item Value. I have pointed this to a data item which stores the "Selected Year" value. But I am getting blank values.

Please help !!!

Thanks
Pravin

[Grim]

Is this maybe what your looking for?

Dynamic Columns
http://www.ibm.com/developerworks/data/library/cognos/reporting/dynamic_report_design/page570.html

[pravin.cognos]

Heyy Grim

Thanks for the reply. I am looking to change the Title of the column in Crosstab as per the user selection. Please have a look at the screen shot. Hope it make things more clear..

Regards
Pravin.

[barrysaab]

try to use crosstab space.Thanks

[pravin.cognos]

Thanks for the reply, Barrysaab..

But that didnt work out :( I even tried with the Crosstab space with the text but it is showing blanks. I tried to create a dataitem with paramdisplay values of the prompt values and placed it in the rows but in the output, I got those values in the Row heading itself but not in the intersection :(

Please let me know if there are any other options to get the prompt values in Crosstab intersections..

Pravin

[pravin.cognos]

Any suggestions !!!!

Pravin

[pricter]

In the "text source" select report expression and place each parameter for each column

[pravin.cognos]

Thanks for the reply, Pricter..

But the values I need here is text value "Totals" its not available in the parameter value.  :(

Regards
Pravin

[blom0344]

Can't you rebuild the crosstab by adding a dataitem with value 'Totals' and start with CTRY_Name in the columns, nest the new dataitem to the left of it and finally nest the year UNDER these nodes?
The node for 'Totals' should automatically yield values summarized for all countries per year..