Auto Slice Category by Name

Please help,

I have a graph like this,
there are names and categories along with their ranking.

for example, if I choose the name "RAHA" and in my data enter the POS category. and I want to create a ranking table based on its category without taking action to click on the Category filter.

So it's like automation without choosing a filter category, if I choose one name and see the ranking of the name based on the name category. 

Thanks,