-
1. Re: Filter two or more columns based on values
Shinichiro MurakamiJun 13, 2018 9:20 PM (in response to Leonardo Albuquerque Filho)
HI Leonardo
Could you please attach your sample data as twbx format.
Shin
-
2. Re: Filter two or more columns based on values
Ritesh Bisht Jun 13, 2018 10:06 PM (in response to Leonardo Albuquerque Filho)Hi Leonardo,
Not sure if I understood it full but here is my suggestion
For example
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 )
Thanks,
Ritesh
-
3. Re: Filter two or more columns based on values
Leonardo Albuquerque Filho Jun 14, 2018 7:36 AM (in response to Shinichiro Murakami)Hi Shinichiro,
I attached a sample data as twbx format. I omitted others columns. This is a huge file.
-
4. Re: Filter two or more columns based on values
Jim DehnerJun 14, 2018 7:35 AM (in response to Leonardo Albuquerque Filho)
Good morning
If I understand the question try using this filter set to true
it returns this
your workbook is attached
Jim
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
-
-
5. Re: Filter two or more columns based on values
Leonardo Albuquerque Filho Jun 14, 2018 7:49 AM (in response to Ritesh Bisht)Hi Ritesh,
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.
-
6. Re: Filter two or more columns based on values
Leonardo Albuquerque Filho Jun 19, 2018 3:05 PM (in response to Jim Dehner)Thanks Jim!!