Chart help?

[Vidit]

Hi

please suggest the solution?

this needs to be done using chart expresssions.

thanks for help

[sunny_talwar · Accepted solution]

Try this expression:

=If(Prod = 'All', Sum(TOTAL Value), Sum(TOTAL Value)-RangeSum(Above(Sum(Value), 0, RowNo()-1)))

[Vidit]

Quite close, it worked.

Thanks