+ Reply to Thread
Results 1 to 2 of 2

Custom Sorting a Slicer for a table - not a pivot table

  1. #1
    Registered User
    Join Date
    03-19-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    27

    Custom Sorting a Slicer for a table - not a pivot table

    Hi all.
    Hope to receive some help here.
    I am trying to custom order a slicer that I have linked to a table (not a pivot table).

    I know you can create a custom list and have it sort that way but I want to be able to send this file out to other people with the custom sort in place on the slicer and setting up a custom list is only good on my PC.

    I also understand that you can create a custom sort in Power Pivot and I have tried that but since my data is a table and not a pivot table I cannot connect the slicer I created from a sorted list in power pivot to it.

    There has to be a way to do this so it is not user specific. I don't think I can ask everyone to create a custom list in their Excel just to see a custom sorted slicer for this report.

    Are there any workarounds? Please help.

  2. #2
    Registered User
    Join Date
    03-19-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    27

    Re: Custom Sorting a Slicer for a table - not a pivot table

    Nobody? Anybody?

+ 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. [SOLVED] Slicer to control table and pivot table
    By chriscla in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-04-2020, 03:02 PM
  2. [SOLVED] Pivot Table and Slicer
    By nancyching1711 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-25-2017, 04:25 AM
  3. Replies: 7
    Last Post: 05-18-2017, 07:58 PM
  4. Pivot Table and Slicer Help
    By matt85webb in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-28-2016, 11:14 AM
  5. Pivot table and slicer help
    By finchfinch in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-23-2016, 07:36 AM
  6. [SOLVED] Use slicer selections on one pivot table to filter another pivot table
    By porkandbeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 12:30 AM
  7. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 AM

Tags for this Thread

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