Hi Rommel,

Drag the date field onto your pivot table as a row or column field, then
right-click it and select 'Group and Show Detail' from the drop-down menu.
Should be easy from there,

Go to http://www.edferrero.com/tutorials.aspx for more info.

Ed Ferrero
http://www.edferrero.com


How can i create a report by Year, Qtr, day using pivot?

Is it possible?

I have 200,000 data on my clipper program, and it has all the details by
date, can i use pivot to summarize report by year, qtr, day without
programming...

Thank you so much!