Hello everyone,

I'm working on this report where I'm showing sales data monthly (the sales numbers are actually summaries of each invoice record in the database and I'm grouping the results monthly).

So it looks something like:
01/2008 - $1500
02/2008 - $1800
...
01/2009 - $3000
02/2009 - $5000
03/2009 - $1300

...for several years. 

What I would like to do is create a Graph that will allow me to create several series' for each of the years shown. This way we can look at monthly trending from year to year. So in the example above I would have one line series (I was thinking a line chart) for the 2008 months, and another line series for the 2009 month sales.

The problem is that all the data is coming from one field (in this case an "Ext Price" formula which is the amount for the invoice minus any discount that invoice line has.

Any idea how I can do this?

Hey Jyothi,

What you suggested wasn't exactly what I was looking for, but it put me on the right track. Your idea gave me 3 series (which is what I wanted), but because it uses the "{inv_date}" field (which includes year), the series did not superimpose each other (it was like 1 series but broken into sections).

So what I did was I created a Month formula and used that as my first "On Change Of" field. The result is exactly what I was looking for, in the X Axis I have months, and then I have a series for each year.