Beatrix
12-03-2017, 11:25 AM
Hi Everyone ,
I have got a pivot table and I use slicer to select multiple items from pivot table.
The problem is there are approximately 100 items listed in pivot filter and usually 20 of them selected and users can change the filter dynamically.
However I am trying to list the multi select items at the top of the slicer as it's not easy for users to go through the long list to see the selected items one by one. I was wondering if it's possible to sort the slicer to display selected items first on slicer please?
Cheers
B.
I have got a pivot table and I use slicer to select multiple items from pivot table.
The problem is there are approximately 100 items listed in pivot filter and usually 20 of them selected and users can change the filter dynamically.
However I am trying to list the multi select items at the top of the slicer as it's not easy for users to go through the long list to see the selected items one by one. I was wondering if it's possible to sort the slicer to display selected items first on slicer please?
Cheers
B.