Forum Discussion

Astroraf's avatar
Astroraf
Data Integration
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 ma...
dashboards & reporting
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