+ Reply to Thread
Results 1 to 4 of 4

Not able to connect 2 tables to a slicer

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    20

    Not able to connect 2 tables to a slicer

    Dear All,

    I am trying to join connection to two tables to a single slicer. Not able to do so as the Reporting connection is greyed out. Attaching the file. Would hugely appreciate a quick help.

    Regards
    Kaushik
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Not able to connect 2 tables to a slicer

    Deleted
    Last edited by Shareez Saleem; 10-08-2020 at 02:48 AM.

  3. #3
    Registered User
    Join Date
    02-18-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    20

    Re: Not able to connect 2 tables to a slicer

    Hi ! It says invalid attachement. Could you please re upload with a different name?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,547

    Re: Not able to connect 2 tables to a slicer

    I believe that what you want to do is going to require producing pivot tables with a connection as described in the video tutorial linked below.
    https://www.youtube.com/watch?v=AibLsRM-QbI
    I have modeled the information from the video using your data tables.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] pivot slicer connect to another set of data
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2019, 04:24 AM
  3. How to connect slicer
    By ziyan89 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-10-2019, 03:39 AM
  4. How to connect slicer
    By ziyan89 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-23-2019, 11:19 AM
  5. Slicer to connect same column in two sources
    By aaallday in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2018, 07:49 PM
  6. [SOLVED] Can't Connect Slicer & Timeline To Two Pivot Tables
    By rahul_ferns76 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-28-2017, 04:11 AM
  7. Is It Possible to Connect A Slicer to Two Pivot Tables?
    By NewJerichoMan in forum Excel General
    Replies: 2
    Last Post: 04-26-2015, 01:35 PM

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