Cumulative Percentage to Target

[#1]

Hi Everyone,

Please have a look at the attached graph  and data.I am trying to calculate Cumulative % to target based on this data, I have tried using' Full Accumulation' option but it's not correct.

[sunny_talwar · Accepted solution]

What are your expressions here? Assuming you have Sum(Sales), try this

RangeSum(Above(Sum(Sales), 0, RowNo()))/Sum(TOTAL Sales)