Hello - I have a variable where the value of the variable may be Car = 1. I need to use this value as a condition in a filter. This variable is created by a drop-down field in a excel spreadsheet.
The data looks something like this. The variable can be 'Car = 1' OR 'House = 0' OR 'Cell Phone = 1', etc.
| Customer Name | Car | House | Cell Phone |
| Peter Parker | 1 | 1 | 0 |
| Tony Stark | 1 | 0 | 1 |
| Natalia Romanova | 0 | 1 | 1 |
Simply using the variable in a filter does not seem to work. Can anyone help with this?
