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,