Line chart with value in percentage of first month

[curiousfellow]

In this simplified example I have Year and Month as dimension and sum(value) as expression.

Now I want to have the sum(value) displayed as a percentage of the first month.

When I have a table-chart it can be done by showing the absolute value and use the the function before, but I cannot get it done in a line chart, in which I only want to show the percentage.

Please see example

[bharathadde]

Try this

=sum(value)/sum(total value)

[curiousfellow]

Total would give me the total of all months I think, and should be the total of the first month of the year

[bharathadde]

This will work

=(sum(value)/sum(Total <month>value))*100

[curiousfellow]

(Total <month>value)) will give me the sum for every month number. I need the sum of the first month per year

[curiousfellow · Accepted solution]

Think  I solved it:

sum(value)

/

sum( {<month={1}>} TOTAL <year>value )