Different year in graph

[#1]

Hi

I would like to make a graph where different year is presented by each line in the chart.

I count number of incomming invoices each year.

on the x-dimension i have months

on y- dimension i have the sum

In th table where i count the number of invoices i have a collumn with the HistoryDate, se picture below.

[its_anandrjs]

Hi,

You need to create a seperate expression for the years.

Regards

Anand

[#3]

How do you mean. I have to seperate the year in the history table?

Like this?

And then use a set expression?

[#4 · Accepted solution]

The solution was like its.Anandrjs said: Split the date field so that year is displayed in a seperated collumn then I used the set analysis for each expression:

Sum ( { [ HistoryYear1 ] = { ' 2011 ' } > } ) Historycount)