Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Vidit
Creator
Creator

Chart help?

Hi

please suggest the solution?

offset.jpg

this needs to be done using chart expresssions.

thanks for help

1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

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


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this expression:

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


Capture.PNG

Vidit
Creator
Creator
Author

Quite close, it worked.

Thanks