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??
In cases like that, we apply Drill down.