Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
09-25-2025

How to filter a table/pivot table: Filter one column that does not equal another column?

Hi DRay​ Liliia_DevX​ ,

I am trying to see if there is logic where I have a pivot table and I want to filter one column based on another column that do not equal, so getting all the results that match within a widget filter or maybe a formula filter. 

dashboards & reporting

2 Replies

    • HamzaJ's avatar
      HamzaJ
      Data Integration
      09-29-2025

      Hey Astroraf​ ,

      You would need to use a formula and then filter on that formula. It can , i think, only be done with a CASE-/IF-statement. If your column is numerical you can do;

      case
when max(A)=max(B) then 1 
else 0
end

      Hamza