Selection on pivot table

[#1]

Hi, I have a question about selection in pivot table.

here is my data:

What i expect is, when i insert percentage, let's say 60 to 68. I want to check the quantity for each brand of one person. If at least one brand in the range of 60-68 i want to show all the data. We can see that brand A from person A has percentage 67%. because the requirement is at least one data, the condition return true and show all data of person A. here is the result I expect:

Person B not shown because none of each brand has fullfill the range between 60 to 68.

Really appreciate your help.

Thanks

[tresesco]

You can aggregate and use the similar logic to identify and flag the Person members in the script, like:

Load

          ....

          If(Sum(...)/Sum(...).., 'Yes', 'No') as PersonFlag

From <> group By.......;

Now, this flag can be easily used in the front end to filter your Persons..  This will reduce the overhead in the front-end,  however, it becomes a static kind of analysis and takes toll on reload time.

[#3]

Hi Tres,

Would you mind to modify my sample file to get the result I expect Tres ?

Really confuse about it.

Big thanks to you for helping me.

Here i attach my raw data (excel)

Thanks