Selection in Pivot Table

[#1]

Hi,

I have a question about selection in pivot table,

I want to select data based on total value.

This one is the data shown when there's no input on percentage.

When i input the percentage, let's say range between 70 - 80 so, i want to check the total value, on above table is 73% for person A and 65 % for person B. So i want to show only data from person A. This is the data i expect

I also attach my sample file for additional information what i've done.

really appreciate your help, Thanks

[lironbaram · Accepted solution]

hi

have a look at the attach example

[#3]

Hi Liron,

Wow yes that's right Liron. You are a great problem solver. Thanks for your idea.

But may I know how to make it ? what did you change ?

[lironbaram]

i added a total qualifier to the expression when checking if the result is in the range

so for all branches of a person the expression uses the total value of the person

[#5]

Wow big thanks Liron.

You solved my problem perfectly.

Thanks