IN Cognos 8 Report Studio the Requirement is in COLUMN CHART I have to show Quantity & Revenue for each order methods ( there are 7 order method) for each product line
1. Product line on category , order method on series , revenue on measure
2. Revenue on Y1 axis & Quantity on Y2 axis
3. Revenue for each Order method for each product line is bar column & Quantity for each Order method for each product line is shown as line.
Result will be like : on x axis each product line will have
1) 7 bars ( one for each order method ) showing revenue
2) 7 lines (one for each order method ) showing quantity
I tried with COMBINATION CHART also but not able to do it. I think I am missing some step please help me.
Its urgent kindly guide me
1. Product line on category , order method on series , revenue on measure
2. Revenue on Y1 axis & Quantity on Y2 axis
3. Revenue for each Order method for each product line is bar column & Quantity for each Order method for each product line is shown as line.
Result will be like : on x axis each product line will have
1) 7 bars ( one for each order method ) showing revenue
2) 7 lines (one for each order method ) showing quantity
I tried with COMBINATION CHART also but not able to do it. I think I am missing some step please help me.
Its urgent kindly guide me