Pivot Table always one selected value

[#1]

While we can configure list box to 'always one selected value', can we do the same for pivot table or at least to be able to configure the similar feature in different way. Any advice?

[krishnacbe · Accepted solution]

Hi,

You can create a list box for the dimension in pivot table and set the property "Always one selected" and then remove that list box.

In pivot table also it will reflect the one Selection.