data table straight

[#1]

Hi, I have a question,

i have a percentage filter with a data like this :

I want to show data based on percentage filter. let's say i input percentage. So i want to check quantity for each person per brand. If at least one brand is in the range of my selection, so i want to show all the data of person one. For the data above the result i expect is like this

I have try using calculated dimension and it runs perfectly, but the data load performance is so poor (very slow) when i use large data. I also attach the qvw file for what i've done before.

[settu_periasamy]

Hi,

Got your point. But i don't have an idea now. May be , will wait for others suggestion.

[jagan]

Hi,

Can you attach sample data file?

Regards,

Jagan.

[#4]

Hi Jagan,

here is my raw data file.

Thanks

[jagan · Accepted solution]

Hi,

Please find attached file for solution.  Changed script and arrived one file.

Regards,

Jagan.

[#6]

Hi Jagan,

sorry for late reply.

wow, that's a great idea Jagan, it's solve my problem perfectly

Super thanks for your idea.