Conditional filtering

Question

Hello All,

I want to create a workflow where amount less than $100 should be filtered out only if it is less than $100
for all the rows where key and code combination is same.

I want yellow highlighted rows in output.

conditional filtering.xlsx

noopurjain · Answer

@Qiu Here is the sample output.

conditional filtering.xlsx

noopurjain · Answer

Please find the example in attached sheet.

I want to exclude rows where amount is less than 100 for each and every occurrence of same key and code combination.

conditional filtering.xlsx

T_Willins · Answer

Hi @noopurjain,

Do you want to include or exclude the rows with the same key and code for $20 each?  This workflow would include these rows as the sum of the rows would be $200 and would be in the True anchor of the Filter tool.  If this is different than what you are looking for, please provide further clarification.