Forum Discussion

dill78453468's avatar
dill78453468
Regular Visitor
2 years ago

conditional Filter in new Column

I have 4 columns
Customer

Entity that made the sale

Revenue

source (where revenue is coming from)

 

I need to conditional filter sources in a new column:

  • By Customer showing revenue
  • but if the revenue is coming from only 1 praticular source, then the Customer should become "Other"

I have tried using a conditional column to no avail as it only allows 1 condition

 

 

1 Reply