2 Year Cumulative Line Chart Help

[R_Mitchell]

Hi there,

I have created a line chart comparing 2 years worth of sales data as below:

I have the dimensions Week and Fiscal Year and the current measure "Sales (inc. VAT)". I want to be able to see the year sales cumulatively rather than week by week so I can see a continual upward chart. Any advise on what Expression I need to write?

Many thanks.

Rob

[sunny_talwar]

May be this

Aggr(
  RangeSum(Above(Sum([Sales (inc. VAT)]), 0, RowNo()))
, YearField, WeekField)