Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Filter on multiple column

Hi everyone, how can I apply one filter on multiple columns. Like I wanted to filter out columns having with same zero values. However, if there's non-zero value in it, it will not be applied. As see...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    You are welcome.  Change the criteria to Not equal to 0 to factor in both positive and negative values.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the Filter pane, apply a condition on this measure - "Staff estimated v actual hours" as >0.

  • ronaldbalza2023's avatar
    ronaldbalza2023
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Hi Ashish, thanks for taking the time on this. Your solution somewhat solve my problem, however, how can I include the rows having negative values? Thanks so much!

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      You are welcome.  Change the criteria to Not equal to 0 to factor in both positive and negative values.

      • ronaldbalza2023's avatar
        ronaldbalza2023
        Icon for Continued Contributor rankContinued Contributor
        5 years ago

        Apologies, may I know which one is it here? I used the is not 0 then negatives were gone. Thanks!