COGNOiSe.com - The IBM Cognos Community

Hi ,

In crosstab report Is that possible to swap the columns and rows in Cognos Report at runtime? If so how do i proceed to that ?

As i used to work on OWC Pivot Table where i can swap the rows and columns, so i am wondering if i can achieve the same functionality in Cognos Report at runtime too?

Thanks

Abd what would be the condition and timing of such swap?

Hi Darek,

Thanks for the reply. Here is my Goal for swaping ....Let me give an example

Let say int he cross tab if Years on Columns and Country on Rows, i amy be validating Country wise sales of a particular year, for a particular case i would like to swap means what ever i can do in the Design time (Click on SWAP icon) i want to achieve the same thing at runtime.

            1998   1999  2000
USA       30%    40%   80%

UK          20%    50%    45%

EGY         10%    5%       6%

now if i apply swap the years will be on rows and country will be on rows, i want this in runtime. The same functionality as a Microsoft Pivot Table where u can swap the Measures as u wish to analysse the data

Hope i am clear

Thanks

Hi Darek, (I am posting my question again as some spell mistakes which changes the meaning)

Thanks for the reply. Here is my Goal for swaping ....Let me give an example

Let say int he cross tab if Years on Columns and Country on Rows, i amy be validating Country wise sales of a particular year, for a particular case i would like to swap means what ever i can do in the Design time (Click on SWAP icon) i want to achieve the same thing at runtime.

            1998   1999  2000
USA       30%    40%   80%

UK          20%    50%    45%

EGY         10%    5%       6%

now if i apply swap the years will be on rows and country will be on Columns, i want this in runtime. The same functionality as a Microsoft Pivot Table where u can swap the Measures as u wish to analysse the data

Hope i am clear

Thanks