I have been successful in using combination of rangesum/above in an expression to calculate cumulative percentages based on two dimensions (Month and Year). However, this expression only works correctly in a Pivot Table and Table format. When fast changing to a Line Chart, the expression calculates a different result.
The expression is: = rangesum(sum(Cost), above(sum(Cost),1,rowno())) / rangesum(sum(Revenue), above(sum(Revenue),1,rowno()))
Attached is a copy of the qvw with the desired line graph layout.
Anyone have any suggestions as to where I have gone wrong in relation to the line graph?