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

How we can apply expand and shrink functionality in cognos

Started by tushar gaurav, 01 Aug 2014 10:09:10 AM

Previous topic - Next topic

tushar gaurav

How we can apply expand and shrink functionality in cognos..
e.g suppose we have a table like below:
Product Line   Product Type   Product Name   Revenue
PL1   PT1   PN1   100
PL1   PT1   PN2   120
PL1   PT2   PN3   130

Now when we shrink we have data like
Product Line Revenue
PL1               250

When we expand,we have data like
Product Line   Product Type   Product Name   Revenue
PL1   PT1   PN1   100
PL1   PT1   PN2   120
PL1   PT2   PN3   130

How we can implement this scenario??

qvixote