Pivot Table: group dates by filing period
My PST (Provincial Sales Tax) filing periods are October 1 to March 31
and April 1 to September 30. I'd like to create a pivot table based on
my table of purchases (named range: Purchases) and have the dates
grouped by filing period. Of course the default ranges don't allow for
this kind of flexibility so I'm guessing I'll need some code...
Can anyone help me out?
Thanks,
KZ
|