I have a dashboard where i would like to hide a particular Pie-Chart when an other value is selected.
Ex: Consider i have Product(as dropdown box) and Market(as Pie-Chart) values in my dashboard.
I'm now seeing both by default, but when a user selects a particular Product the Pie showing market results must disappear.
Thanks All for the quick suggestions.
stalwar1 your suggestion worked for me.
I was trying with a Count(distinct) and the chart would disappear completely. But, now it perfectly suits my requirement.