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

Swaping Columns and Rows at Runtime in CrossTab

Started by kalyan_sekhar1, 19 Aug 2005 01:47:26 AM

Previous topic - Next topic

kalyan_sekhar1

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

Darek

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

kalyan_sekhar1

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


kalyan_sekhar1

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