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

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.

Rafael Ferreira

Posted 1 year ago·Last reply 10 months ago

3 comments

DRay

·10 months ago

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.

Rafael Ferreira

OP1 year ago

Hey TriAnthony HamzaJ just curious if you can help with this one.

Hamza Jap-Tjong

·1 year ago

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