Remove Similar Rows

Hi, Sdhn420 

Please correct me if I misunderstood your question.

I usually do the below.

- Groupby customer and material by Max/Sum/Min/Avg/etc. of Sales Value

Or,

- I create one more column that only picks positive value, for instance, and "N/A" for negative.

   if [Sales Value] >0 then [Sales Value] else "N/A"

  Then, I filter out the "N/A" value from the newly created column.

   it only remains what you want in the original Sales Value Column.

I hope it helps.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.