0 Replies Latest reply: Aug 30, 2011 11:35 AM by cliffwong RSS

    Rangesum works for Pivot/Flat table not Line Chart

      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?