Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Date Filter External Value
I am familiar w/ how to use the date filter feature within a PivotTable where
I can either filter on a date in the list or enter a date myself in the dialog box. However, I am trying to determine if I can do a date filter within a PivotTable and it base the filter off of a date entered by the user in a field outside of the PivotTable. I tried to enter a cell reference in the date filter dialog box, but whatever you enter in the dialog box has to be a valid date. Any suggestions on how I can accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report Filter in PivotTable | Excel Discussion (Misc queries) | |||
Change the location of external data feeding a pivottable | Excel Discussion (Misc queries) | |||
Pivottable Filter | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Named Sets as a filter | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) |