+ Reply to Thread
Results 1 to 3 of 3

Pivot value filter top 10 doesn't affect slicer items

  1. 07-27-2021, 06:05 AM #1
    Marcinrd
    Marcinrd is offline
    Registered User
    Join Date
    07-27-2021
    Location
    NL
    MS-Off Ver
    2013
    Posts
    8

    Question Pivot value filter top 10 doesn't affect slicer items

    Hello Gents,
    I've been stuck on this problem for solid 2 weeks and can't find solution on google, perhaps you will be able to help

    I have a pivot table based on access db with thousands items where I want to see only top 10 by their value. However value filter has no effect on corresponding items in a slicer. I need slicer to update other pivots according to top 10 items.

    Manually picking 10 items from thousands is a nightmare. I got VBA that was picking items one by one but it takes hours to run.

    Any suggestions what can I do to make this task easy and reasonably fast?

    Thank you in advance!
    Attached Files Attached Files
    Last edited by Marcinrd; 07-27-2021 at 06:16 AM.
    Reply With QuoteRegister To Reply
  2. 07-27-2021, 06:06 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: Pivot value filter top 10 doesn't affect slicer items

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-27-2021, 06:17 AM #3
    Marcinrd
    Marcinrd is offline
    Registered User
    Join Date
    07-27-2021
    Location
    NL
    MS-Off Ver
    2013
    Posts
    8

    Re: Pivot value filter top 10 doesn't affect slicer items

    Sorry my bad, example attached
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting Slicer Visible Items only and using in a Filter formula
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2020, 01:25 PM
  2. Only display pivot table items that meet ALL selected slicer criteria?
    By GregStewartPTC in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-23-2020, 01:11 PM
  3. code that will count the number of items selected in a slicer on a pivot table
    By asmi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2017, 12:57 AM
  4. Pivot Chart changes total when I select items from the slicer
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-11-2016, 01:55 PM
  5. Filter a 2nd pivot with the inverse of a slicer
    By spikey_plant in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-27-2015, 12:55 PM
  6. Updating a pivot filter with another pivot updated by a Slicer
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2014, 04:08 PM
  7. Deselect all pivot slicer items
    By K1M6O in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2014, 04:37 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1