So, I'm trying to drive excel to allow a filter on a before date to only then show rows of data before that certain date without referencing the actual dates themselves. I just want to show the filtered data only and not the dates which match the filter condition. Basically I wish I could place the date field in the actual pivot table report filter, but doing so loses the ability to then filter on an actual or before or range of dates.
Clear as mud, no doubt.
Cheers, Paul.
Clear as mud, no doubt.
Cheers, Paul.