Pivot Table Drill Down using Start and End date

1druid1

New Member
Joined
Mar 31, 2018
Messages
1
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top