Need to group an attribute as others whose corresponding measure values is 0

I have a use case which I need to implement I want to group all the 'product name' values as 'others' wherever I have a discount = 0, and I also want to sum up all the sales value for the products which have been grouped and display in the newly created row

please drop in your suggestions on how I can implement this scenario in the visualizer report

Thank You