7 Replies Latest reply: Mar 13, 2015 8:54 AM by Felipe Goitre RSS

    Running/Cumulative Total Calculations

      Dear All


      I am using QV to calculate impact of the spare part and service costs compared to the production.


      My raw data has Product, Month, Year, Supplier, Production, Service & Spares.


      For each product, I want to calculate the impact of spare parts and service cost compared to the production level and how it change month by month.

      By using a Pivot Chart, I can obtain exactly what I looking for.



      When I want to put in a line chart the column "cost / 1000", the cumulative functionality is not working anymore.

      The formula I am using for Cost / 1000 is:



      Please let me know if the formula used for the line chart should be different.

      What I want to obtain is:

      Thanks in advance.