+ Reply to Thread
Results 1 to 2 of 2

Showing summary information in pivot slicer

  1. #1
    Registered User
    Join Date
    06-18-2012
    Location
    Blore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Showing summary information in pivot slicer

    Hi there,
    I have a pivot table with half a million rows. One of the fields is gross margin which goes from 0% to 100%. I want to insert a slicer on gross margin but instead of showing all the values of GM, I just want to display 3 options in the slicer : 0-25%, 25-50%, >50%. Is that possible without using a macro? Any help is appreciated.

    Warm regards,
    M

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    286

    Re: Showing summary information in pivot slicer

    I think I'd be inclined to create a new column called "Margin Range" and fill it with
    =IF([margin cell ref]<=25%,"<=25%",IF([margin cell ref]<=50%,"25-50%",">50%"))
    Include that column on your pivot table, and you can slice on that instead.
    Kind Regards,

    Out of the Hat

    "Computers are stupid - they do EXACTLY what you tell them to"

    If I've helped you with a problem, please say thanks by clicking the small star icon on the left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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