4 Replies Latest reply on Feb 22, 2018 10:09 AM by Pedro David

Filter Top % Decrease in

Pedro David Feb 20, 2018 8:21 AM

Hello,

I have a table that shows the percent of total variation of scores (related to previous weeks).

The time frame is always something like the last 4/5 weeks and I would like to show only the rows in which occurred variations <-5% in the last week

I'm aware of some previous discussions on this subject, like filter N top, but I need the filter to look only to the last variation.

I tried to adapt them to my case, but with no success.

A sample of my workbook enclosed.

Regards

Filter n%.twbx 25.2 KB

1. Re: Filter Top % Decrease in

Jim Dehner Feb 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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
3. Re: Filter Top % Decrease in

Jim Dehner Feb 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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions