Hello,
I am new to Tableau and I want just to filter the last two columns without blacks values or that has both last two columns values above 10, for example. This will reduce the number of lines. How can I do this?
Thanks in advance for any help.
Jun 13, 2018 9:20 PM
HI Leonardo
Could you please attach your sample data as twbx format.
Shin
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
Hi Shinichiro,
I attached a sample data as twbx format. I omitted others columns. This is a huge file.
Jun 14, 2018 7:35 AM
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.
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.