Thanks so much Pecoflyer, Got a clearer explanation from other source to figure it out but looking at your solution - I see its what you tried to explain just that I couldn't translate it well.
Simply put - Right click the data in the Date Pivot table column and select range and specify the option of Month, Quarter ......
Thanks Gebobs (U're awesome) that works too.
|