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,