Consulting

Results 1 to 4 of 4

Thread: Sort / Filter Slicer Entries

  1. #1
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location

    Sort / Filter Slicer Entries

    Just dipping a toe into the PowerPivot waters and experimenting with slicers using a regular PT

    Q1 -- Is it possible to have the slicer entries sorted other than A-Z?

    Example: I have a PT with states sorted High to Low based on sales $. The Slicer shows the states A-Z, and I'l like to have the slicer sorted high to low by $

    Q2 -- Is it possilble to have the PT Top 10 filter reflected in the slicer choices?

    Example -- Instead of the slicer showing 50, just show the top 10?

    Thanks

    Paul

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    1. No - you have only A-Z, Z-A and custom lists available.
    2. No, I'm afraid not.
    Be as you wish to seem

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    1. Darn
    2. Darn



    That's what I was afraid of.

    Paul

  4. #4
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    Would be nice functionality though - I'll suggest it for the next version of Office.
    Be as you wish to seem

Posting Permissions

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