-
1. Re: Filter Top % Decrease in
Jim DehnerFeb 20, 2018 9:18 AM (in response to Pedro David)
Good morning
please see the attached
is this what you expected as a result
this th1s the formula for the filter
Drag it to the filter shelf and set to true
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.
-
Filter n%_v10.2.twbx 27.1 KB
-
-
2. Re: Filter Top % Decrease in
Pedro David Feb 21, 2018 3:10 AM (in response to Jim Dehner)Hello Jim,
Sorry but maybe I didn't explain well.
What I really need is to see only the rows in which there was a variation <-5% in the last variation (is this case last week).
Is this possible?
Thank you
Pedro
-
3. Re: Filter Top % Decrease in
Jim DehnerFeb 21, 2018 10:11 AM (in response to Pedro David)
Yes just change the filter to - this will only look at the final filtered value in your Week filter
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.
-
Filter n%_v10.2_v10.2.twbx 26.4 KB
-
-
4. Re: Filter Top % Decrease in
Pedro David Feb 22, 2018 10:09 AM (in response to Jim Dehner)Hi Jim,
It works well.
Many Thanks,
Pedroo