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
Bookmarks