Consulting

Results 1 to 4 of 4

Thread: sorting slicer to list the multi select items first

  1. #1

    sorting slicer to list the multi select items first

    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.
    Sub Learning VBA()

    Do
    Practice Most Useful VBA Examples
    Loop Until Become an Expert in VBA

    End Sub

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,306
    Location
    Moderator Bump
    Please take the time to read the Forum FAQ

  3. #3
    Sorry SamT, does it mean same question raised already in this forum please?
    Sub Learning VBA()

    Do
    Practice Most Useful VBA Examples
    Loop Until Become an Expert in VBA

    End Sub

  4. #4
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,306
    Location
    No. It means I just "Bumped" your thread to the top of the Unread Threads list.

    As a courtesy, we generally do that when a Thread goes unanswered for at least 24 hrs.
    If it doesn't get answered after that, it's usually because no one here knows the answer.
    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •