In matrix2. For category item how can I select E5 and E4 simultaneously.
The filter capabilities that you describe don’t quite work the same way in Quantrix as they do in Excel. Perhaps this video Episode 190 of the Quantrix Authority (https://www.youtube.com/watch?v=B6zxfvRgWSE) will give you some direction on how to accomplish what you desire. This demonstrates how robust Quantrix can be as compared to that lesser program.
At first you posted this topic in the Formulas and Functions section of the forum. And then you say that your question doesn’t concern formulas.
If I understand you correctly, try this formula in Matrix2:
- : = Join(Select(@Item, OR(@Item = “E5”, @Item = “E4”), 1), “, “)