Do we have any way to dynamically show and hide dimension in Qlik Sense Pivot table.
For example we have country and states data showing in pivot table.
Also I am providing user to select country or State check box.
When user select Country check box, Pivot should display Country data and when State check box is selected, State data should be displayed.
And when both is selected , the Pivot should display both data.