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 match within a widget filter or maybe a formula filter. 

dashboards & reporting

3 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

  • DRay's avatar
    DRay
    Sisense Employee
    12-03-2025

    Hi Astroraf​ ,

    I’m following up to see if the solution offered by HamzaJ​ worked for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.