Consulting

Results 1 to 4 of 4

Thread: Sleeper: Sorting slicer to list the multi select items first

  1. #1
    VBAX Mentor
    Joined
    May 2010
    Location
    London
    Posts
    307
    Location

    Sleeper: 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
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    Moderator Bump
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Mentor
    Joined
    May 2010
    Location
    London
    Posts
    307
    Location
    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
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    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.
    I expect the student to do their homework and find all the errrors I leeve in.


    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
  •