Drag Executive to Row as First Pill, Numbers to Text Label and again Executive to Filter and Select from Filter.
Well, I think I may have figured it out....
I created a Set of the filter...the created another sheet then dragged it on my dashboard then apply the filter with all worksheets....it may be a better way to do this but this works for now.....feel free to comment an easier way....still learning..
i have created sample data set to resolve your problem and data set looks like below
Step 1: Drag Name to rows and Value to Text
Step 2: Drag Name to filter and select like below
Step 3: Click on filter and select show filter
Selecting AB Name will give respective name and valure
Hope this helps kindly mark this answer as correct/helpful so that it will helpful to other and as well to close the thread
Thanks you very much everyone!!!!