+ Reply to Thread
Results 1 to 1 of 1

Extracting filtered data selected using slicers and pivot tables

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Yorkshire, England
    MS-Off Ver
    2013
    Posts
    1

    Extracting filtered data selected using slicers and pivot tables

    Hi all

    This is my first post here, so be gentle, please!

    I have a workbook that contains a 'raw data' table, from which I've pulled several pivot tables and set up a dashboard of sorts to allow the data to be filtered and interrogated graphically.

    The data relates to 'work incidents' and has 'date of incident', 'incident type', 'incident location' and 'incident description' columns in the raw table. I've used pivots and slicers and timelines before with this data and it's all been good. (eg Show me all the incidents in June, etc and a bar chart showing where all the incidents in June took place is updated.)

    What I would like to add is that, when slicers are used to filter the data, as well as the graphs updating, the details of the incidents populate a dynamic table on the same sheet. So a user can select, for example, all the incidents in June, and as well as graphs showing where they occurred and what type they were, they also get a table with the details of those incidents in June.

    Does that make sense?

    I've attached a VERY simplified version of what I'm talking about, which hopefully will help.

    Any help would be gratefully received!

    Cheers

    Noel
    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. slicers on copied pivot tables
    By stephme55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2016, 02:07 PM
  2. slicers for sorting pivot tables
    By stephme55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2016, 03:49 PM
  3. slicers for sorting pivot tables
    By stephme55 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-07-2016, 03:38 PM
  4. I want to synchronize slicers from several pivot tables
    By flore in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2015, 08:33 PM
  5. Replies: 0
    Last Post: 11-12-2014, 08:39 AM
  6. Pivot tables/slicers
    By Kittykatinla in forum Excel General
    Replies: 0
    Last Post: 11-06-2014, 02:21 AM
  7. Using Timelines/Slicers to filter 2 Pivot Tables
    By eightythree in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2014, 04:12 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