+ Reply to Thread
Results 1 to 5 of 5

slicer report connection

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    98

    slicer report connection

    hello
    i had a dash board which contain
    1- profit
    2- number of reports
    i had slicer of month (jan/feb....etc) to filter profit and number of reports
    now i had made new pivot table which contain numbers of samples test each month
    the problem that i want to connect earlier slicer with the pivot table but when click on report connection i cant see my new pivot table (samples)
    any help

  2. #2
    Registered User
    Join Date
    06-21-2017
    Location
    Missouri, USA
    MS-Off Ver
    2007 through 2019
    Posts
    71

    Re: slicer report connection

    Slicers will only see pivot tables with the same data source. You'll need to update the data source on the original pivot table in order to link the slicer to both tables.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    98

    Re: slicer report connection

    so the only solution is making pivot table again and then link the slicer to it
    i hope there is easier solution

  4. #4
    Registered User
    Join Date
    06-21-2017
    Location
    Missouri, USA
    MS-Off Ver
    2007 through 2019
    Posts
    71

    Re: slicer report connection

    I'm assuming you added a column to the original data you made the first pivot table with and now including that column you have a second pivot table. If that's right, then you just
    click anywhere in the first pivot table, go to the Analyze tab, and change the data source to include the new column. You wouldn't need to change the output of either pivot table.
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    98

    Re: slicer report connection

    my new table (number of samples at new sheet)
    will see tomorrow your help and will report here

+ 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. Slicer report connection for dissimilar fields
    By johnnylzep in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-07-2018, 12:44 PM
  2. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  3. Report connections under slicer
    By Dipti Sajit in forum Excel General
    Replies: 1
    Last Post: 02-07-2017, 02:36 AM
  4. Report connections in Slicer
    By Dipti Sajit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2017, 02:09 AM
  5. Timeline slicer connection question
    By jugdish in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2015, 02:19 PM
  6. Slicer connection issue
    By dougers1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2015, 08:08 AM
  7. VBA : Updating Pivot Source = Lost Slicer Connection
    By flipsyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 06:17 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