Hi All
I have been trying to figure this out for a few days and have given up and hoping you can help.
I have a spreadsheet that has a Data table, a Pivot Table and a Dashboard. My users only get to see the Dashboard and the other sheets are hidden.
At the moment I have a few slicers that the user can click on that drills down the information displayed on the Dashboard and it all works great, however one gripe my users have is the date selection, at the moment my Date Slicer basically lists all the unique dates in the Data Table and the users have to click on the dates they want to drill down.
I have now been told this is not good enough and they want a Start Date and End date entry box that will drill down this information based on the dates entered into the boxes.
Any help on how to achieve this, I honestly thought this would be something that was easy to do as its such a common reporting method.
Cheers
D
I have been trying to figure this out for a few days and have given up and hoping you can help.
I have a spreadsheet that has a Data table, a Pivot Table and a Dashboard. My users only get to see the Dashboard and the other sheets are hidden.
At the moment I have a few slicers that the user can click on that drills down the information displayed on the Dashboard and it all works great, however one gripe my users have is the date selection, at the moment my Date Slicer basically lists all the unique dates in the Data Table and the users have to click on the dates they want to drill down.
I have now been told this is not good enough and they want a Start Date and End date entry box that will drill down this information based on the dates entered into the boxes.
Any help on how to achieve this, I honestly thought this would be something that was easy to do as its such a common reporting method.
Cheers
D