I want to Create drop down filter using Pivot table i should select only one value from drop down ,Multi selections should be restricted in drop down .
In attached example in pivot chart i should select only one value from drop down ,Multi selections should be restricted in drop down .I should select A or B not both at a time .. It is working in input box that we can select one drop down at a time. Same thing i want to achieve in Pivot chart.
