Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Put a "Value Filter" on a "Report Filter" in a Pivot Table

Status
Not open for further replies.

jackosieves

Petroleum
Feb 5, 2010
24
0
0
US
I've got a pivot table, in which I am using an "Ending Date" as a Report Filter. I would like to be able to apply a "Value Filter" to this, but Excel 2010 is not letting me. I understand that I can check off multiple dates, but I have a lot of dates in there. I'd like to see the information after a certain date, etc. without spending quite some time clicking on boxes.

The "Insert Splice" feature would work, if I could figure out a way to select all values from a spot in the list to the last selection within the Splice Tool. Does anybody know if this can be done? I've tried a few things.

Thanks for looking at my post. Any input would be greatly appreciated.


Regards,

jackosieves
 
Status
Not open for further replies.
Back
Top