How to create a cumulative return chart using power view

[trilliansounds]

Hi,

Is there a way to take the following data and build a chart using power view (pls see attached) - so it can be part of a BI filter and easily refreshed as new data is added:

chart question.xlsx

Taking the data in A2:C15, totting up the returns from each day by system and then plotting each system and the total returns on the y axis and days on the x axis.

Thanks in advance,

[trilliansounds]

Getting closer to a solution, googling running totals using DAX:

http://javierguillen.wordpress.com/2...niques-in-dax/

Added a new calculated field with the following formula "=calculate(Sum(Range[$]),Range[System])"

But it comes up with a query failure error (see attached)

chart question (with calculated field).xlsx