Revenue on Y1 axis & Quantity on Y2 axis

[haripali]

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 have also attach a SCREEN SHOT.

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.

[blom0344]

You are plotting 5 categories (product line) against 7 series (method).
That is basically 5*7 combination for each measure = 35 bars + 35 linepoints

As far as I can judge the graph seems to plot the data that you assign it to plot..

[haripali]

Hi blom,

there are only 7 bars in each product line for each order method showing revenue measure

Kindly look at the attachment

[blom0344]

I read your original post a couple of times and have seen the image. To me , it looks like it is doing what it should.
7 bars per product line * 5 productlines = 35 bars total.

But perhaps I'm missing your point..

[haripali]

Bloom ...as far as " revenue " is concerned I am able to show in chart as " BARS " on " Y1 axis " so far it is simple

but I am not able to show " quantity " as " LINE " on " Y2 axis " when " order method " is already on series.

Bloom let me know ur mail id or u can contact me at haripali@gmail.com & I will revert back.

[rockytopmark]

I agree, the graph looks to be doing what it should.

Maybe a mockup (drawing) of what you are trying to acheive would enable better advice?

[haripali]

some people were not able to see screen shot that I have attached on 25 Apr 2008 05:30:04 AM but in later post at 25 Apr 2008 09:50:37 u can see the attachment

Somehow I am not able to show data as shown in screen shot

Senior guys guide me

[rockytopmark]

So your screen shot is your goal or what you are getting from Cognos?

Confused amateur

[haripali]

Yes the screen shot is my goal.
I have to create this chart...
Am i missing something here

[rockytopmark]

Here you go.