Hi Friends and Experts,

I have a line chart which displays one line for current year data and the other line is for last year data for easy comparison. I am using oracle sqlout to pull the data from the table.
Here I have a problem in the last year data.
My chart gives me two lines with dots for each month.

But When We hover over any dots it says the (CurrentYear:201301$1000 ) for the current year and the same for the lastyear (LastYear 201301$2000). The month Value is not changing. It should be like this LastYear 201201.

It is a very simple straight forward query getting month,year and sum(value) on that month for both the years in one single record like this

curr_year CValue Last_Year LValue
201301 $1000 201201 $1200
201302 $2000 201202 $2200
...

Anybody has any idea How should I display the data.


GRAPH FILE SQLOUT
SUM
&curr_year 'CurrentYear'
&Last_year 'LastYear'
BY


Thanks,

Thanks,

Hi Mary,

A colleague of mine has reviewed this topic. Would you be able to post an image of this graph so that we can better visualize what you're wanting to accomplish?

Thanks and regards,

Kathryn

Hello again. Actually, it would be better to open a case on InfoResponse Online since there doesn't appear to be a quick answer.

Regards,

Kathryn