Calculating a field and then using as a filter

I need to know if a list of stores allows card and cash payment. I don’t have any category field that indicates it to know, but I can infer knowing if the means of payment used in the transactions. In this way I would like to create a calculated field to be used in a filter, which allows me to know if the use of card and/or cash is allowed in each store.

I used countIf+ Ifelse, and In but I can’t create the field that I need to use as a filter

can you try to do it in two steps:

  1. create the ifelse calculated field at the data prep layer
  2. in the analysis layer, create the countif calculated field

Let us know if it works,