4 Replies Latest reply: Oct 5, 2016 12:20 PM by Josh Chang RSS

    tricky question about column total divided by accumulated sum

    Josh Chang



      I would like to create a line chart based on a pivot chart data.

      Here is the pivot table,


      The x-dimension of the line chart will be the Time2Fail values while y-axis will be the subtotal of Time2Fail / the accumulated sum.

      for example, when x=Time2Fail=1, the y= subtotal of Time2Fail=1 (which is 7 in the pivot chart) / the latest accumulated sum=24847

      when x=Time2Fail=2, the y=8/22898

      ... and so on.


      I'm struggling to find write an expression for this scenario.

      Can someone help me?

      The qvw and qvd are attached.