3 Replies Latest reply: Dec 19, 2012 7:53 AM by Vlad Gutkovsky RSS

    Cumulative expression?

    Siva Dandu

      Hello,

       

      iam looking for something to calculate cumulative expression for the following requirement, i tried with many options but couldn't succeed.... Please help.

       

      This is my expression for the bar chart:

      =((sum(A)-Sum(B))/Sum(A))*100

       

      Iam calculting the cumulative expression as a line in the same chart.

      for the first month , the expression is same

      =((sum(A) for Jan-Sum(B) for Jan)/(Sum(A) for Jan)*100

       

      for the second month, i want to find the ((sum(A) for Jan, Feb - Sum(B) for Jan,Feb)/(Sum(A) for Jan, Feb))*100

       

      for the third month, i want to find the ((sum(A) for Jan, Feb,Mar - Sum(B) for Jan,Feb,Mar) /  (Sum(A) for Jan, Feb,Mar))*100

       

      Please find the attachment for the qvw file.

       

       

      Regards

      Siva