Line chart showing monthly values over several years

[nigel987]

Hi there,

I have following problem and would appreciate any advice.

I have a line chart which shows the monthly sum of revenues (expression: sum of revenues, dimension: month).

My problem is, that it shows the average values for all months over several years (screen 1 in the attached image).

What I would like to have, is the monthly sum for all months for every year (screen 2 in the attached image).

Any ideas how I could solve this? Thanks for any help.

[mphekin12]

I belive it would really help you in this case.  Please see my reply above.  Thanks.

[mphekin12]

I forgot to mention that your expression would need to be changed as well.  This should work:

     Sum(order_line_price)

[kkkumar82]

Hi,

Use Date(datefield,'MMM-YYYY') in your load script.

Thanks

Kiran Kumar