Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Three Criterions on Filters

Hello everyone,   I found that here we can maximum have just 2 criterion, can we have more than 3?   Thanks in advance,   Best regards, Hanson
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi you could create a custom column that if the CustomerGroup contains Type A or Type B or Type C, mark them as "Y", others mark as “N”. Then filter this custom column. Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous thanks for reply, Reality is a bit of more complex,
It might be column A contains "A" or column B contains "B" or column C contains "C"

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You can apply multiple columns filter in Filters pane just as below screenshot:

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous If so, the three filters are in AND relationship or OR relationship?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      These three filters should be AND relationship... Could you please share some mockup data in your model and your expected result in order to provide a suitable solution? Thank you.

      Best Regards
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.