This content has been marked as final. Show 4 replies
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.