Hi Guys,

I have to create a dashboard for to 10 clients. So I created a pivot with top 10 filter on clients, based on which I created Chart as well. but now my Problem starts, when I create slicer from pivot it show all 100+ client from the data. In addition to this I want only one item to be selected from my slicer at a Time.

Any VBA code which can help me?

Hope I was able to explain clearly

Thanks in advance.