Forum Discussion
nilanjenator
Mar 23, 2020Copper Contributor
How to use start and end dates in a Pivot table instead of a timeline
I have a date column in my Pivot table. I use a timeline to select the dates. However, this is a bit clumsy. I'd like to show fields for start date and end date. How can I then use those values a...
nilanjenator
Mar 24, 2020Copper Contributor
Here is a file.
Also here is what I am trying to do:
What I am trying to do is to allow others to modify the results. I just want them to select the start date and end date and refresh the pivot table for updated results.
mathetes
Mar 31, 2020Silver Contributor
In connection with another thread, I've come across the linked YouTube video which explains how to accomplish what you are trying to do. It's tricky, but effective.
https://www.youtube.com/watch?v=sHfWRb2yUrM