In advanced filter I can tell Calc to only show values that are >30 (as an example) but, how do I tell it to only show values that are >D2, where D2=SUM(A2:C2)=30 so, if any value gets modified, the filter can still apply with these new values? Also, would I need to update the filter in any way?
Never mind, =CONCAT(">";D2) and doing again the advanced filter seems to work 