Could you please attach your sample data as twbx format.
Not sure if I understood it full but here is my suggestion
I just want to have rows with Profit > 129 and Sales > 800 ------I should not see row no. 3 there since it is having -ive profit as -254
I will write below calculation and filter it to 'Yes'
You can see below it has reduced the overall number of rows with the relevant data rows only
Please mark it as HELPFUL and CORRECT if it really helped you so that it can help others as well (If not let me know the problem or post a twbx file )
I attached a sample data as twbx format. I omitted others columns. This is a huge file.
If I understand the question try using this filter set to true
it returns this
your workbook is attached
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Amostra_all_v10.2.twbx 2.0 MB
I attached the twbx. First, I want to see the lines that has values on the last two columns. Second, I want is filter the lines that both values on the last two columns are above 10.