I'm experimenting with using a pivot table as an intermediate step in a
report I'm doing that has been slow. It seems to help speed up the process a
bit, I just need help filtering down to the dates I need.
Each transaction has a date associated with it, I have gotten the
getpivotdata to work except for being able to have it only include
transactions with dates after my begdate and before my enddate.
I need to figure out how to get something like this to work:
=GETPIVOTDATA("Sum of Lbs",'sheet2'!$A$3,"Customer",A4,"Budget LOT
#",B4,"transaction date",=b2,"transaction date",<=c2)
where b2 is the cell that has my begdate and c2 is the cell that has my end
date, so far I'm just getting errors.
Or is it possible to have the pivottable automatically filter itself based
on the dates entered into those cells? I have not been able to figure that
out either, either solution would work.

Thanks