+ Reply to Thread
Results 1 to 1 of 1

multiple slicers/ filters simultaneously

  1. #1
    Registered User
    Join Date
    12-07-2022
    Location
    Hoorn
    MS-Off Ver
    2210 excel
    Posts
    22

    multiple slicers/ filters simultaneously

    Hi All,

    I have been working on a little project of my own and was wondering if anyone could help me out with this.

    The idea is as follows:

    I have three datasets. Sales, Warranty and Returns. Sales regards complete products. Warranty and Returns comprise sub-components.
    In a dashboard, I am visualizing the number of times a component/product is sold, returned or claimed for warranty.
    Product owners can find components of interest in this sheet. After all, they may want to redesign components that are returned extraordinarily much.

    My question is two pronged:
    There is one specific demand to make the dashboard so that a PO can specify the product of interest to filter the pivot tables on. The added value is that we can diligently investigate products without the data getting clouded by components of other products.

    Additionally, there is a request to (temporarily) eliminate certain components from the graphs manually. After all, once a component is on the PO's radar, there is no need to get returning indications on this component as we are already taking action.

    These two filters should ideally work ambidextrously.

    Many thanks in advance! your time is being appreciated
    Attached Files Attached Files

+ 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: 08-20-2022, 07:23 AM
  2. Create Slicers which are linked to multiple filters
    By pwaccs in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-22-2020, 07:19 AM
  3. Detect changes to slicer filters for slicers connected to a table
    By jmwbowen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2020, 09:44 AM
  4. Count Selected values in Filters/Slicers
    By drho in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-16-2015, 03:24 PM
  5. Using Filters with Pivot Slicers
    By Rachel12345 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2015, 02:43 AM
  6. Replies: 0
    Last Post: 04-02-2014, 06:13 PM
  7. [SOLVED] Slicers vs Filters
    By dwhite30518 in forum Excel General
    Replies: 12
    Last Post: 06-05-2012, 04:58 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