Gen pivotcache with data filtering/conversion
 

I've done a lot of excel/vba work but am at a loss as to how to create a
pivotcache (- pivottable) with filtering and data conversion from an
existing querytable simply. Here is the example: I have a querytable with a
date column and other data. I want to generate a pivot on this data for a
given date range and slice and dice by month. I don't want to have to filter
the data and normalize the date procedurally, nor do I want to affect the
source querytable. What's easiest? Thanks.