We have a dashboard with multiple sheets, 3 of which are pivot tables (built as 3 sheets in the dashboard) –
- The measures in all the 3 pivots are the same (premium, commission, and client count)
- The dimensions are Coverage, Carrier, and Wholesaler Type (one for each of the pivots)
Our goal is to have one sheet instead of 3 (since the measures are the same).
I have built an inline table called Selection with values Coverage, Carrier, and Wholesaler Type.
Listbox ‘Selection’ is shown on the sheet to enable the user to select the right dimension. Option ‘Always One Selected’ – is checked, so the user cannot select more than one value.
Using $(='[' & GetFieldSelections(Selection) & ']') gets the value of user selection in the pivot as a dimension.
We need to ‘unselect’ the user choice in the ‘Selection’ ListBox – when the user goes to another sheet. Only this selection should be unselected. Other filters / slicers selected by the user should remain selected.
Is there a simple way to do this?
Many Thanks!