+ Reply to Thread
Results 1 to 2 of 2

Slicer to cover multiple Pivots from different sources

  1. #1
    Registered User
    Join Date
    08-07-2016
    Location
    London
    MS-Off Ver
    Excel 10
    Posts
    5

    Slicer to cover multiple Pivots from different sources

    I am currently pulling a dashboard together in which there are multiple data sources showing different information. I've created a number of pivots from these and have slicers linked to all pivots coming from the same table.

    However is it possible to link a slicer between pivots which come from different data sources?
    For example in both of my data sources there is a column title Payroll Week for which the Weeks in the column are the same across both data sources. However as I need historical data included this means that the contract names are repeated in each column which is what is currently stopping me being able to create a relationship between the two tables.

    For example on the attached I've got two different data tables, creating pivots of different data however the weeks are the same, is there anyway to link it so when I click on Week 1 on one slicer it changes both pivots?

    Thanks,
    David
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Slicer to cover multiple Pivots from different sources

    Not directly no. You'd need to add both tables to data model using PowerPivot (or Data tab->Create Relationship) , and then also add date/week dimension table as well.

    Then create relationship between dimension table and the two tables.
    Use dimension table as source for your slicer. This will allow slicing of both pivot using same dimension.

    Since I don't have Excel 2010 I can't do sample file (Data model from latest version isn't compatible with 2010 version).

    Link may be of some help.
    http://www.informit.com/articles/art...13314&seqNum=3
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Slicers to sync multiple pivots from multiple data sources?
    By cantona_lives in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-21-2017, 12:33 PM
  2. Multiple Pivots with Same Slicer - How can I link them all?
    By kreinking in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-31-2016, 01:46 AM
  3. Replies: 4
    Last Post: 12-17-2015, 04:20 PM
  4. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-24-2015, 07:29 PM
  5. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel General
    Replies: 1
    Last Post: 08-24-2015, 04:49 AM
  6. Using 1 slicer for multiple pivots (diff data source)
    By Roskame in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2015, 08:10 AM
  7. Update multiple pivots tables with external data sources at once
    By ayalami79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 11:53 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1