+ Reply to Thread
Results 1 to 2 of 2

One slicer for two inverse pivot tables

  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    Portland, OR
    MS-Off Ver
    365 Pro
    Posts
    1

    One slicer for two inverse pivot tables

    Hi all,

    I'm curious if there is a way to make a single slicer filter "all but" in one pivot table, and "only" in another.

    Essentially I have bunch of items, their usage dates, and usage duration. I want to be able to select an item on a slicer and have its average usage duration per quarter pop up compared to the average time of all items minus it.

    I got the grouping by quarter down, and the basic slicer addition. I'm struggling with the execution of the slicer in such a way that it allows for the chosen item to be compared to the (rest - chosen). I know there has to be an easy way to do this, but right now all I see is a super inefficient VBA code that checks every slicer item.

    Thanks!

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,891

    Re: One slicer for two inverse pivot tables

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    Note: As you are new I will add it for you.Please read forum rules which you might have missed

    https://www.ozgrid.com/forum/index.p...les-inversely/

+ 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. Replies: 1
    Last Post: 09-11-2019, 11:54 AM
  2. One Slicer to control 2 Tables (Not Pivot Tables) in 2016
    By sparkyster in forum Excel General
    Replies: 1
    Last Post: 05-09-2018, 03:00 PM
  3. One Slicer to control 2 Tables (Not Pivot Tables) in 2016
    By sparkyster in forum Excel General
    Replies: 1
    Last Post: 05-09-2018, 01:25 PM
  4. Replies: 3
    Last Post: 12-04-2017, 01:55 PM
  5. Replies: 5
    Last Post: 12-04-2017, 10:33 AM
  6. Replies: 19
    Last Post: 04-04-2016, 02:58 PM
  7. 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

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