I have a field called Billing_Type with values Credit Card, Cash, Money Order and COD. I need to create a filter pane that does 2 things:
1) Omits COD as a choice, which I was able to do with this IF statement: if(Billing_Type='COD', null(), Billing_Type)
2) Combine Cash and Money Order into one option called All Cash and when a user clicks on All Cash the KPI's and visualizations combine those 2 values. Another way to think of it is, instead of someone choosing Cash and then also choosing Money Order to see that combined filter, I want the union to be on one choice called All Cash.
When correctly done, the filter pane should only show Credit Card and All Cash as the only 2 options.
How can I do that in my Filter Pane along with my line of code to omit the COD option?