Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - How to create dynamic filters
I want to generate a Pivot table based on some filters. e.g. my data
contains project start and end dates in two columns. i have close to 100 projects in my data. Now if I generate the pivot for whole data, I see all the projects. I want to filter the projects for which either of start or end date is between two given dates (user entered). I had been breaking my head for long to acheive this. Please help. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
Pivot Table Filters | Excel Worksheet Functions | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Pivot table filters | Excel Discussion (Misc queries) | |||
Using dynamic range to create pivot table | Excel Discussion (Misc queries) |