+ Reply to Thread
Results 1 to 3 of 3

slicer not putting items in alpha order but table does

  1. #1
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    slicer not putting items in alpha order but table does

    I have data formatted as a table with multiple pivot tables summarizing it. I have two slicers that are connected to all of the pivot tables and they work perfectly except for one thing:

    One of my slicers won't put things in alpha order correctly.

    The data from the table sorts as expected in the original table, but the slicer has a few weird entries at the top that don't follow the alpha order I get in the source table itself.

    I have checked that there are no leading spaces, that each of the cells is formatted as text, refreshed the pivot tables, but I still see the same odd ball entries at the top of my slicer.

    The cells all contain data in the following pattern: ###_-_@@@@@@@@@ (3 digit number followed by space dash space then the title of a department in all caps)

    I really am flummoxed by this...any ideas?

    BTW - I just realized my pivot tables are also behaving in the same errant way as the slicer...sigh...

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: slicer not putting items in alpha order but table does

    Attach a data sample, it will be easier for you to help

  3. #3
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Re: slicer not putting items in alpha order but table does

    I ended up just not even bothering with the slicer. Thanks though

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slicer for Top 5, 10, 15 items by Sum
    By DKolev in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 12-06-2016, 05:29 AM
  2. Replies: 2
    Last Post: 03-20-2015, 01:57 PM
  3. Replies: 5
    Last Post: 11-26-2014, 04:39 AM
  4. Slicer not Sorting in Date Order
    By Trig79 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-18-2014, 09:58 AM
  5. Replies: 2
    Last Post: 05-03-2014, 03:55 AM
  6. Sort The list of items by Alpha / numeric in their proper sequential order
    By DON_BLACK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 03:42 PM
  7. Custom Sort items not in alpha order
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 12-10-2012, 07:32 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1