Good afternoon everyone.
I am wanting to create a dynamic summary page for staff which draws in data from numerous tables.
So on this summary page I want to place the slicer that selects the staff. Once clicked I would like it to show the name as sort of a heading and the have all the different data related to that staff populate below which I draw in from half a dozen tables that come from various sources (like workhours, annual leave, sickness, supervisions, etc).
So I guess what I'm asking is, is it possible to extract the value from the active slicer selection to use as a variable to extract data from all these tables.
The reason I want to do it dynamically is that I am looking at 80+ staff and don't want to create separate worksheets for each of them.
Or am I looking at this scenario in a too convoluted way and should I maybe think about combining the different data through power query?
Many thanks for your help and I do apologise if this is a trivial question with a very easy answer and I have just gone wayyyyy too complicated in my head over how to solve this 😀 😀
Not sure I fully understood, but when you want to read out the selection of a slicer you would create a ‘helper’ pivot table as demonstrated in the attached file. Would this achieve what you are looking for?
If not, please come back with an example file that resembles your actual data and indicate what result you want to see.
Thank you so much. That is exactly what I was looking for and it's such an elegant solution.
In all my pondering I never ventured down the path of referencing a helper-cell. Brilliant.
Again thank you so much 😀 👍 👍
