Use a table calculation to distinguish whether it is up or down, then add this into text. Then create an adhoc calculation of last=0 in columns:
Then drag this into filters and set it to true:
So what's happening here is a table calculation running across the table to see if the values went up or down. Then another table calculation to show only the last column.
Please see attached workbook.
Up or Down.twbx 10.9 KB
The trick is to hide the row that you don't want to see instead of filtering it. Right click on the row and select "Hide". That will keep the data included in your set but not show it in your view.