as you see in attached image, i made a pivot table with sales revenue data by country and a filtering option control for dashboard level.
If i choose Philippine in filtering option, I still see all countries not only chosen countries, even though chosen country is highlighted in color.
Can I just see only chosen items in pivot table?
By default the selection of a widget is set to 'Highlight'. One can modify this setting to accommodate the 'slice and filter'. To do this, access the pivots editor, see screenshot 1, then go to the settings, and select 'slice and filter'
please see screenshots for more detail.