Hi, I am trying to put together an Excel solution for a friend who works with special needs people.
FYI, I am developing in Office 365, however the workbook will be used in Excel 2016.
I have two main data sets:
A name list
A results list
I have already built pivot tables based on the results list, and added slicers to filter graph data. Currently slicing year level, calendar year results, teacher/class results, student results and subject results. (I am happy to re-do these pivot tables if need be)
What I am trying to do is set up a slicer on the same chart based on the YELLOW fields in the name list.
(1) I am having some trouble linking two data sets. I have been slowly working through this but not there yet (any advice welcome!).
(2) What is really doing my head in is the fact the YELLOW field names should be data values to be able to use these in a slicer (as far as I know) along with the slicers previously mentioned. I want the field names to be available as slicer values/selections and filter the results data accordingly.
I can't get my head around how to get this to work... Any suggestions?
(PS I don't mind if I need to do advanced data filter extract as I am already using a command button to refresh data, so adding extract in the same macro would be OK. However I need minimal manual data manipulation by the end user, AND the solution must be available in the suite of slicers)
I have attached a couple of pics of the (incomplete) data sets. Couldn't work out how to attach the workbook itself.
Many thanks for any suggestions...
FYI, I am developing in Office 365, however the workbook will be used in Excel 2016.
I have two main data sets:
A name list
A results list
I have already built pivot tables based on the results list, and added slicers to filter graph data. Currently slicing year level, calendar year results, teacher/class results, student results and subject results. (I am happy to re-do these pivot tables if need be)
What I am trying to do is set up a slicer on the same chart based on the YELLOW fields in the name list.
(1) I am having some trouble linking two data sets. I have been slowly working through this but not there yet (any advice welcome!).
(2) What is really doing my head in is the fact the YELLOW field names should be data values to be able to use these in a slicer (as far as I know) along with the slicers previously mentioned. I want the field names to be available as slicer values/selections and filter the results data accordingly.
I can't get my head around how to get this to work... Any suggestions?
(PS I don't mind if I need to do advanced data filter extract as I am already using a command button to refresh data, so adding extract in the same macro would be OK. However I need minimal manual data manipulation by the end user, AND the solution must be available in the suite of slicers)
I have attached a couple of pics of the (incomplete) data sets. Couldn't work out how to attach the workbook itself.
Many thanks for any suggestions...
